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.