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 2014 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.
