outputting results of sp_publication_validation

  • 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."

  • johnherbert858 - Tuesday, February 21, 2017 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."

    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