Hi everyone,
I disabled replication on my local sql server. I would assume publication and subscription folder will be empty after I refresh Enterprise Manager. however that's not the case.
Publication folder is empty after I disabled replication, but subscription folder is not empty, what is going on?
I kept refresh subscription folder under 'replication', I can't get rid of those subscriptions? how can I get rid of them?
thanks
Kevin
Please try running sp_removedbreplication in the relevant databases.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Monday, February 20, 2012
obsolete subscriptions still exist
Labels:
assume,
database,
disabled,
empty,
exist,
folder,
local,
microsoft,
mysql,
obsolete,
oracle,
publication,
refresh,
replication,
server,
sql,
subscription,
subscriptions
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment