Checking publications are subscribed to all subs

[tyaramis]

Hi All

How can I checked the publication are subscribed to all subscribers?
is there any stored procedure or method to do this?

Thanks alot

Tolga

[MAK]

use publisheddatabasename

go
sp_enumfullsubscribers 'publication name'

[tyaramis]

Actually I found a script in internet like this, but its complicated to understand...I could not understand how it works.. what are the comments at the begining?
You can look the script at the following link...

http://www.selectstar.co.uk/kb/repli...umplog152.html

Can u explain this procedure?

Thanks

Tolga

[MAK]

You have to run that script on a distribution database.

If you know where the distribution is, you can query all the replication tables to find more details.

MSsubscriber_info and MSsubscriptions stores all the information. Just browse all the tables in the distribution database.