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)
 Could not drop Subscription

Author  Topic 

sagitariusmzi
Posting Yak Master

113 Posts

Posted - 2009-08-17 : 11:43:57
Hi, Can someone please guide/solve this error

"Tech-A is not defined as subscriber, The Subscription could not be droped at this time.change database context to Account"


any help regarding this will be highly appreciated.

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-08-17 : 11:54:27
you drop the subscriber from the publisher db.

see here: http://msdn.microsoft.com/en-us/library/ms184385.aspx
Go to Top of Page

sagitariusmzi
Posting Yak Master

113 Posts

Posted - 2009-08-17 : 12:04:04
i am using Merge Replication and i had already tried this one

sp_dropmergesubscription

but got the same error
Go to Top of Page

govthamb
Starting Member

27 Posts

Posted - 2009-08-18 : 05:34:23
sp_Merge replication does not support 'sp_dropsubscription'
Go to Top of Page
   

- Advertisement -