Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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
An easier approach - to try first - would be to simply run EXEC sp_removedbreplication 'dbNameHere'; That'll let you keep any publications/topologies going on with other dbs. If you do this, though, just make sure that you manually delete any/all SQL Server Agent Jobs associated with your publication and topology. – Michael K Campbell Apr 1 '15 at 19:09

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


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.