Home > How to get Publisher Details from Subscriber > How to get Publisher Details from Subscriber

How to get Publisher Details from Subscriber

Working with different versions of sql servers i came across with an issue,How to get Publisher information from Subscriber.

To get to know I ran sql profiler for couple of time and captured an undocumented stored procedure which helped in getting the information I needed about the publisher.

exec sp_MSenumsubscriptions ‘both’

The stored procedure can be found in subscribed database.

The same can be achieved from table MSreplication_subscriptions, can found in subscribed database.

SELECT * FROM MSreplication_subscriptions

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: