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

• Ammad Baig

  Mr or Mrs. 500

  Points: 577

  More actions

  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!

• Michael Valentine Jones

  SSC Guru

  Points: 64818

  More actions

  June 14, 2007 at 2:30 pm

  #713054

  DROP INDEX Rules.IX_Rules

• Alexandr Volok

  SSC Journeyman

  Points: 83

  More actions

  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

• Ammad Baig

  Mr or Mrs. 500

  Points: 577

  More actions

  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?

• Alexandr Volok

  SSC Journeyman

  Points: 83

  More actions

  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