How to remove a table from Replication

  • Hi,

    How to remove a table from Replication, using SQL server, Merge Replication

    With Regards

    Dakshina

  • Hi Dakshina,

    You mean article? See sp_dropmergearticle in BoL.

    HTH!

    /Elisabeth

    elisabeth@sqlserverland.com
    MCITP | MCT
    http://sqlblog.com/blogs/elisabeth_redei/
    http://linkedin.com/in/elisabethredei

  • Hi,

    If I remember correctly, you can only do this if there is no subscriber.

    Regards

    Graeme

  • Right click on the publications --> Properties --> Articles

    Un-Check the article that you want to stop replicating.

  • Hi,

    I tried with right clicking the article and unchecking it, but we cant uncheck the article.

    With Regards

    Dakshin

  • Use procedures to do this.

    Drop the subscribers to the Article...sp_Dropsubscribers..is that the one ?

    Drop the Article from the publication...sp_DropArticle..

    G

Viewing 6 posts - 1 through 5 (of 5 total)

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