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