Saturday, February 25, 2012

Delete Subscriber

Hi,
I have two server, One is a publisher and one is a subscriber with Pull
Type.
After I use "Disable Publishing and Distrubution", I sucessfully remove any
entries in the Publisher Server, but there is still an entry under the
"Replication" --> "Subscriptions" with the Pull type info. How am I able to
remove that entry
Thanks
Ed
You can have a look at sp_MSenumsubscriptions to see what is happening when
you click on the subscriptions folder. The key tables in each subscribing
databases are sysmergesubscriptions and MSreplication_subscriptions. If this
database is no longer a subscriber, then run sp_removedbreplication, which
removes the redundant system tables. If you want these tables to remain,
then simply locate the redundant record in the above system table and delete
it.
HTH,
Paul Ibison, SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

No comments:

Post a Comment