VALIDATE_TYPE

Replication Programming

Replication Programming

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.

See Also

Help with Replication

Validate Property