September 2010
Intermediate to advanced
1704 pages
111h 8m
English
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—Subscriber server information
• sp_helpsubscription—Subscription information
These stored procedures are all extremely useful for verifying exactly how the replication configuration is really configured. If you execute these stored procedures (from the publication database), you get a great documentation of your complete replication topology that can be included in run books ...