Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Replication summary information Expand / Collapse
Author
Message
Posted Tuesday, November 13, 2007 3:13 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Thursday, November 15, 2007 5:57 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 07, 2014 7:02 PM
Points: 10, Visits: 107
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 »

Add to briefcase

Permissions Expand / Collapse