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(*). |