From: Marc on 25 Jan 2010 15:14
Is there a way to get a list of subscribers by querying the publisher? I'm not able to redirect the out put of sp_helpsubscriberinfo SP to a temp table!
As an alternative I can do it with by running this query against distribution database
select * from distribution.dbo.MSsubscriber_info
But in our prod environement distribution database is hosted on separate servers and I do not have access.
Thanks for your help