Post reply

drop article and cleanup replication

  • August 3, 2017 at 1:38 pm

    #324830

    hi guys, i am planning to drop an article on my transactional publication.  I know to drop the subscription , drop article.  
    My question is when i drop the article , my subscriber table and the three stored procedures used by replication  for this subscriber table are still there, is there a way to clean this up without having to do it manually?

  • August 3, 2017 at 2:06 pm

    #1954042

    DBA-640728 - Thursday, August 3, 2017 1:38 PM

    hi guys, i am planning to drop an article on my transactional publication.  I know to drop the subscription , drop article.  
    My question is when i drop the article , my subscriber table and the three stored procedures used by replication  for this subscriber table are still there, is there a way to clean this up without having to do it manually?

    No, it doesn't drop the objects, just the article from the publication.
    After sp_dropsubscription and sp_droparticle, you need to manually execute drop <WhateverObject>

    Sue

  • August 3, 2017 at 2:16 pm

    #1954045

    thanks Sue, i was hoping maybe with sql 2014 there was a feature to cleanup better than doing manually 🙂

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply