Checking publications are subscribed to all subscribers

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
Message posted via http://www.sqlmonster.com
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
Message posted via http://www.sqlmonster.com
|||The comments presumably just represent the trend of
thinking of the developer. Basically the code is a cursor
to loop through the list of publications and will check
that subscriber 'NY1325CMISRESM2' subscribes to each
publication. Note that each publication is iterated,
while the subscriber is hardcoded, so it doesn't really
do what it says on the tin
Rgds,
Paul Ibison