Post reply

How to remove index/unique key constraint from a table with replication running

  • June 14, 2007 at 9:41 am

    #117133

    Hi,

    We have a mission critical DB in SQL 2k which is currently being replicated. I am wondering if any of you know what steps I should take to

    1. Remove the index IX_Rules from the Rules table in the DB.

    Please let me know as I have to come up a plan to do this.

    Thanks!

  • June 14, 2007 at 2:30 pm

    #713054

    DROP INDEX Rules.IX_Rules

  • June 15, 2007 at 1:56 am

    #713163

    Hi,

    Try this:

    ALTER TABLE [Rules] DROP CONSTRAINT [IX_Rules]

    Kindest Regards,

    Alexandr Volok
    volok.blogspot.com

    MCITP: Database Administrator
    SQL Server Russian Group www.sql.ru

  • June 20, 2007 at 10:30 am

    #714170

    Does the replication needs to be stopped or this could be done on a live replicated DB?

  • June 22, 2007 at 6:32 am

    #714558

    Y'll not have stop replication

    Kindest Regards,

    Alexandr Volok
    volok.blogspot.com

    MCITP: Database Administrator
    SQL Server Russian Group www.sql.ru

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

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