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