Udostępnij za pośrednictwem


VALIDATE_TYPE (Replication ActiveX)

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 and later 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 and later Subscribers.

ROWCOUNT_ONLY

1

Perform only a full row count validation of the Subscriber data.

See Also

Reference

Validate Property (Replication ActiveX)

Other Resources

Validating Replicated Data

Help and Information

Getting SQL Server 2005 Assistance