sp_publication_validation @publication=hmis_oltp_p, @full_or_fast=2, @rowcount_only=2
EXEC sp_publication_validation @publication = 'pb_database_1_to_server_2_database_2', @rowcount_only = 1, -- For SQL Server version 7.0 Subscribers, only a rowcount validation is performed. @full_or_fast = 2 Generated expected rowcount value of 6756 for tb_purchasedink_xref. -- source table SELECT COUNT(*) FROM tb_purchasedink_xref -- 6756 -- dest table on other server SELECT COUNT(*) FROM rep_tb_purchasedink_xref -- 6751
No comments:
Post a Comment