Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 cannot delete Subscription

Author  Topic 

MoneIntuitive
Starting Member

1 Post

Posted - 2013-04-18 : 04:45:09
im using SQL Server 2005
The publisher was deleted. The subscriber not because i cannot delete it.
i can see the subscription, but if i try to delete it, i get error message "the subscription does not exist on the server anymore. Please refresh its parent tree node." when i clear the error message, the subscription disappears.

If i refresh the tree, the subscription appear again.

Any ideas?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2013-04-25 : 18:33:35
See if sp_removedbreplication can fix up the subscriber database. It works on the publisher...

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2013-04-29 : 11:21:50
From the publisher, issue an sp_dropsubscription passing @ignoredistributor = 1
Go to Top of Page
   

- Advertisement -