How to find if the db is a subscribing db ?

I have a server with around 50 dbs. I would like to find out, if any of the
databases are subscribing dbs from other publishers.
I know to find published dbs by seeing the hand icon on the database name in
Enterprise Manager, but not sure how to find out for subscribing dbs
Thanks
Hassan,
you could look in the MSreplication_subscriptions and sysmergesubscriptions
tables on the subscriber or run sp_helpsubscription on the publisher.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Problem is I dont know the publishers. Some publishers are not managed by me
..
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OuEyhP3iFHA.3256@.TK2MSFTNGP12.phx.gbl...
> Hassan,
> you could look in the MSreplication_subscriptions and
sysmergesubscriptions
> tables on the subscriber or run sp_helpsubscription on the publisher.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||OK - then the manual method in the first part would be best :
MSreplication_subscriptions and
sysmergesubscriptions tables.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)