Friday, March 23, 2012

Lingering subscription after disabling Publishing and distribution

Hi,
I have used the 'Disable Publishing and Distribution wizard' to remove all
publications and subscriptions and it went successfully. But why is there a
subscription item listed in the 'Subscriptions' folder under the
'Replication' folder in the SQL enterprise manager in both the publisher
server and the subscriber server? How can I remove it?
Wingman
As you've disabled replication, you can run sp_removedbreplication on each
database that has these remnant replication system tables.
Cheers,
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