Replication Validation Method Constants (SQLDMO_VALIDATIONMETHOD_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 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(*). |