Replication Monitoring SQL Statements
One way to look at the replication configuration and validate row counts, for example, is to use various replication stored procedures, including the following:
sp_helppublication—Information on the publication server
sp_helparticle—Article definition information
sp_helpdistributor—Distributor information
sp_helpsubscriberinfo ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
