Post reply

Check and Drop an Article

  • April 19, 2011 at 5:09 pm

    #236014

    Hi,

    Is it possible to check for an replication article if it exists and drop the article.

    Thanks

    Dhana

  • April 19, 2011 at 8:43 pm

    #1313719

    Sure. You would have to query the database that is published and look in the sysarticles table. You could pull all the pertinent information into variables from that table and syspublications and build a string to execute sp_droparticle.

    Can I ask why you are looking to make this dynamic though?

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

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

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