Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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.

share|improve this question

2 Answers 2

up vote 1 down vote accepted

Just dropped the whole damn distribution and started over. That's all I could figure out.

share|improve this answer

I had the same problem. In the publisher database I deleted the missing article from syssubscriptions and sysschemaarticles. Also in the distribution database from MSsubscriptions and MSArticles After doing that I was able to drop and recreate the publication.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.