Subscription Validation Options
The following options are available on the Subscription Validation Options dialog box for transactional publications.
Options
Compute a fast row count based on cached table information
Validates data by calculating a rowcount at the Publisher and then comparing that value to the rowcount calculated at the Subscriber. The rowcounts are based on cached table information rather than querying the tables directly.
Compute an actual row count by querying the tables directly
Validates data by calculating a rowcount at the Publisher and then comparing that value to the rowcount calculated at the Subscriber and querying the tables at each server directly.
Compute a fast row count; if differences are found, compute an actual row count
Validates data by calculating a fast rowcount based on cached table information. If changes are found, an actual rowcount is calculated by querying the tables directly.
Compare checksums to verify row data
Validates data by calculating a checksum at the Publisher and then comparing that value to the checksum calculated at the Subscriber.
This Subscriber is a server running SQL Server 2000, use a binary checksum
Validates data by calculating a binary checksum at the Publisher and then comparing that value to the binary checksum calculated at the Subscriber.
Stop the Distribution Agent after the validation has completed
Stops the Distribution Agent after any kind of validation has completed.