VALIDATE_TYPE
The VALIDATE_TYPE constants specify the type of data validation to perform on the Subscriber data at the end of the run. VALIDATE_TYPE is used with the Validate property of the SQLMerge object.
| Constant | Value | Description |
|---|---|---|
| FAST_ROWCOUNT_AND_CHECKSUM | 4 | Perform a fast row count and checksum validation of the Subscriber data. |
| FAST_ROWCOUNT_AND_BINARYCHECKSUM | 6 | Perform a fast row count and binary checksum validation of the Subscriber data. BINARYCHECKSUM is not supported by Microsoft® SQL Server™ 2000 Subscribers. |
| FAST_ROWCOUNT_ONLY | 3 | Perform only a fast row count validation of the Subscriber data. |
| NO_VALIDATION | 0 | Do not validate the Subscriber data (default). |
| ROWCOUNT_AND_CHECKSUM | 2 | Perform a full row count and checksum validation of the Subscriber data. |
| ROWCOUNT_AND_BINARYCHECKSUM | 5 | Perform a full row count and binary checksum validation of the Subscriber data. BINARYCHECKSUM is not supported by SQL Server 2000 Subscribers. |
| ROWCOUNT_ONLY | 1 | Perform only a full row count validation of the Subscriber data. |