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 2000 Forums
 SQL Server Administration (2000)
 How to remove pull subscription if publication del

Author  Topic 

Alex_bg
Starting Member

6 Posts

Posted - 2005-12-13 : 03:50:01
Hello,

I am using SQL Server 2000. I have two computers, one is the publisher, on the other I have a pull subscription. Unfortunatelly I have deleted the publication, without removing the pull subscription, so now I don't find a way to remove it. If I try to make a new publication on the same database, I get error 14005.
How can I remove these orphaned subscriptions?

Thanks,
Alex

rb1373
Yak Posting Veteran

93 Posts

Posted - 2005-12-14 : 12:03:10
Have you tried looking at sp_dropsubscription or sp_dropsubscriber? See BOL for more details.
Go to Top of Page
   

- Advertisement -