February 21, 2017 at 8:59 am
I'm running a few replications on Microsoft SQL Server 2008, with a scheduled job to run the validation stored procedure once a week. Is there a way I can output the results that show up in the Distributor to Subscriber History into a table or text file?
Looking for a better way than going into the Replication Monitor and trying to read the history for a couple hundred lines of "Table 'xx' passed rowcount (x) and checksum validation."
February 21, 2017 at 11:39 am
johnherbert858 - Tuesday, February 21, 2017 8:59 AMI'm running a few replications on Microsoft SQL Server 2008, with a scheduled job to run the validation stored procedure once a week. Is there a way I can output the results that show up in the Distributor to Subscriber History into a table or text file?
Looking for a better way than going into the Replication Monitor and trying to read the history for a couple hundred lines of "Table 'xx' passed rowcount (x) and checksum validation."
The data should be in the MSdistribution_history table in your distribution database.
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply