Post reply

Dropping articles in a publication

  • July 26, 2006 at 3:55 pm

    #651763

    you should be able to drop the articles from subscriton. try this:

    exec sp_dropsubscription @publication = 'pub_name'

    , @article = 'Categories'

    , @subscriber = 'sub_name'

    , @destination_db = 'Northwind'

    exec sp_droparticle @publication = 'pub_name'

    , @article = 'Categories'

    exec sp_addarticle @publication = 'pub_name'

    , @article = 'Categories'

    , @source_table = 'application'

    exec sp_addsubscription @publication = 'pub_name'

    , @article = 'Categories'

    , @subscriber = 'sub_name'

    , @destination_db = 'Northwind'

    ******************
    Dinakar Nethi
    Life is short. Enjoy it.
    ******************

  • July 27, 2006 at 3:39 am

    #651816

    Hey Hey, it worked!!!

    Thanks a stack, your help is most appreciated!

  • August 9, 2006 at 8:38 am

    #654093

    Another way is to script out the "drop publication" and "create publication" commands, then run just the ones to drop your specific articles.

    This comes in handy if you need to change the schema of a replicated table. Drop the article, change the schema, then add it back in. Saving the scripts will save you having to figure out all the syntax.

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

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