Solutions:
Using Replicaton Monitor:
Navigate to your Publisher, select a Publication, right-click & select Validate Subscriptions
Next, select the appropriate parameters
The output will be displayed in the "All Subscriptions" tab for the Subscription you have selected.
Using T-SQL:
Execute in your Publication DB with the appropriate parameters:
sp_publication_validation
Output:
Generated expected rowcount value of 147068 for SEARCH_1
Generated expected rowcount value of 327511 for SEARCH_2.
Generated expected rowcount value of 502278 for SEARCH_3.
Generated expected rowcount value of 502278 for SEARCH_4.
Generated expected rowcount value of 128861 for SEARCH_5.
Resources:
sp_publication_validation (Transact-SQL)
|
|
|
|
|
|