Subscription Validation Options (Transactional Subscriptions)
Use the Subscription Validation Options dialog box to specify whether validation should use a row count only, or a row count and a binary checksum.
Options
- Verify that the Subscriber has the same number of rows of replicated data as the Publisher
Select the type of row count validation to perform. For Oracle publications, the only available option is Compute an actual row count by querying the tables directly.
- Compare checksums to verify row data
In addition to taking a count of rows at the Publisher and Subscriber, a checksum of all the data is calculated using the binary checksum algorithm introduced in Microsoft SQL Server 2000. If the row count fails, the checksum is not performed. Select this option only if all Subscribers are SQL Server 2000 or later.
- Stop the Distribution Agent after the validation has completed
By default, the Distribution Agent runs continuously. Select this option to stop the agent after validation is performed. This allows you to check whether validation was successful before continuing to replicate data to the Subscriber.
See Also
Other Resources
How to: Validate Data at the Subscriber (SQL Server Management Studio)
Validating Replicated Data