Detect Existing Subscription on Subscriber

Hi all,
Is there a way to check the subscriber if a particular subscription exists
using SQLDMO ActiveX control? If not, how would it be done through stored
procedure?
Thanks,
Tom
Tom,
on the subscriber you could run sp_helppullsubscription or just query the
MSreplication_subscriptions table - I think this is the easiest method.
Using SQLDMO there is a TransPullSubscriptions collection that could be
iterated, although I'm not too sure if this works on the subscriber.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)