November 13, 2007 at 3:13 am
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.
November 15, 2007 at 5:57 am
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.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply