Post reply

Replication

  • June 6, 2012 at 12:15 pm

    #270263

    I need to drop a table that is used in replication (from sqlserver 2005 to 2008). And recreate the table with some column changes. I cannot drop the table as it is used in Replication? How do I go about this?

  • June 6, 2012 at 1:55 pm

    #1497884

    SQL_Surfer (6/6/2012)

    I need to drop a table that is used in replication (from sqlserver 2005 to 2008). And recreate the table with some column changes. I cannot drop the table as it is used in Replication? How do I go about this?

    Remove the article from replication.

    Jared
    CE - Microsoft

  • June 6, 2012 at 11:18 pm

    #1497992

    SQL_Surfer (6/6/2012)

    I need to drop a table that is used in replication (from sqlserver 2005 to 2008). And recreate the table with some column changes. I cannot drop the table as it is used in Replication? How do I go about this?

    If you want to drop a published table, firstly you need to remove it from the publiscation.

    Just to make some column changes, you don't have to drop the table.

    You can run ALTER TABLE command.

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

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