From: Marc on

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