Replication Validation Option Constants (SQLDMO_VALIDATIONOPTION_TYPE)

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

Replication validation option constants specify the type of validation performed on transactional and merge publications and subscriptions.

Constant

Value

Description

SQLDMOValidationOption_/70Checksum

0

Performs a Transact-SQL CHECKSUM operation compatible with an instance of Microsoft SQL Server version 7.0.

SQLDMOValidationOption_/80Checksum

2

Performs a Transact-SQL CHECKSUM operation compatible with an instance of SQL Server. It is only supported by Subscribers on SQL Server 2000 and later.

SQLDMOValidationOption_/RowCountOnly

1

Default. Performs a Transact-SQL @@ROWCOUNT operation.