I'm having trouble dropping a subscription from my replication setup. The subscriptions do not appear (in SSMS, at least) on the subscribers, but do on the publisher. When trying to drop the subscriptions via either SSMS or sp_dropsubscription, I receive he following error message:
Msg 14068, Level 16, State 1, Procedure sp_MSrepl_changesubstatus, Line 1353
The subscription status of the object could not be changed.
I dropped all articles from the subscription in SSMS, reran sp_dropsubscription, and still received the same message. However, it appears now the only article that sp_helpsubscription is reporting is a table-valued function that does not exist anymore. A table does however exist with the same name.
I tried renaming the table and re-adding the function, but this didn't work. The function did not show up as checked in the published articles list, and manually dropping it still didn't work, giving me the same error message.
Any ideas? Our publisher is running SQL Server 2008 and our two subscribers are running 2005.
Best Answer
Just dropped the whole damn distribution and started over. That's all I could figure out.