Replication summary information

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SS2K5 Replication » Replication summary information

Replication summary information

Rate Topic

Display Mode

Topic Options

Author

Message

sagar-506255

Posted Tuesday, November 13, 2007 3:13 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, March 02, 2009 5:52 AM
Points: 17, Visits: 49

hi,

is there any single stored procedure that returns the information about replication summary like

Publisher
publication database
publication name
publication type
subscriber
subscription database
merge agent location.

this is the information whichwe can see in the replication folder on the subscription tooltip after we set up the subscription.

Post #421418

Mikelyn Mirtica

Posted Thursday, November 15, 2007 5:57 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, April 25, 2013 9:44 AM
Points: 10, Visits: 92

There is no stored procedure that gets you a list if that is what your looking for, but you could write your own query using the system tables to get the same information. For example, I wrote a query that runs nightly to check all our publications and subscriptions and if any are missing, dropped or new it sends a report via Reporting Services and logs to an audit table.

I use the system tables all the time to get the information I need.

Post #422577

« Prev Topic | Next Topic »

Permissions