Validate All Subscriptions
The following options are available on the Validate All Subscriptions dialog box for merge publications.
Options
Verify the row counts only
Validates data by calculating a rowcount at the Publisher and then comparing that value to the rowcount calculated at the Subscriber.
Verify the row counts and compare checksums to verify the row data
Validates data by calculating a rowcount and a checksum at the Publisher and then comparing those values to the rowcount and checksum calculated at the Subscriber. Because checksums can require large amounts of processor resources when validating a large data set, you may want to schedule validation to occur when there is the least activity on the servers used in replication.
Verify the row counts and compare binary checksums to verify the row data (all Subscribers are servers running SQL Server 2000)
Validates data by calculating a binary checksum at the Publisher and then comparing that value to the binary checksum calculated at the Subscriber.