Replication Validation Method Constants (SQLDMO_VALIDATIONMETHOD_TYPE)

SQL-DMO

SQL-DMO

Replication Validation Method Constants (SQLDMO_VALIDATIONMETHOD_TYPE)

Replication Validation Method Constants are used to specify the method of validation performed on transactional publications and subscriptions.

Constant Value Description
SQLDMOValidationMethod_ConditionalFast 2 Default. Performs conditional validation first using SQLDMOValidationMethod_FastCount but reverts to using SQLDMOValidationMethod_FullCount if SQLDMOValidationMethod_FastCount indicates differences.
SQLDMOValidationMethod_FastCount 1 Performs high speed validation, using the rowcnt column of sysindexes.
SQLDMOValidationMethod_FullCount 0 Validates by returning the number of rows, including NULL values, and duplicates using Transact-SQL COUNT(*).

See Also

ValidatePublication Method (TransPublication2)

ValidateSubscriptions Method