I have a merge publication on server A and a push subscription on server B (as it is visible in the list of subscriptions in the treeview in SSMS under the publication.
When I try to remove the subscription by GUI i get the following error:
"B" is not definied as Subscriber for "A"
The subscription could not be dropped at this time
Changed database context to "pubdb" (Microsoft SQL Server, Error 20032)
OK - I know that sometimes this could happen - for any unknown reasons. But I'm familiar with T-SQL so I've decided to remove the subscription with sp_dropmergesubscription a la...
sp_dropmergesubscription @publication = N'dba', @subscriber = N'B', @subscriber_db = N'pubdb', @ignore_distributor=1
When I execute this statement I got the following error in the query window...
Msg 14055, Level 16, State 1, Procedure sp_dropmergesubscription, Line 70
The subscription does not exist.
That makes me puzzled because I see the subs
View Complete Post