Home Forums SQL Server 2005 Administering when I try to drop the index I am getting error "An explicit DROP INDEX is not allowed on index 'dbo.crdtr.crdtr_ak1'.It is being used for FOREIGN KEY constraint enforcement. " RE: when I try to drop the index I am getting error "An explicit DROP INDEX is not allowed on index 'dbo.crdtr.crdtr_ak1'.It is being used for FOREIGN KEY constraint enforcement. "

  • August 20, 2009 at 1:26 pm

    #1042386

    MAK (8/20/2009)

    when I try to drop the index I am getting error "An explicit DROP INDEX is not allowed on index 'dbo.crdtr.crdtr_ak1'. It is being used for FOREIGN KEY constraint enforcement."

    even no one using the db.

    Do you know how to fix it or what can I do, This index is defrag and I want to drop it and recreate this index.

    You will need to find the foreign key that is using this index, drop it first, then you can drop and recreate the index. After doing that, be sure to recreate the foreign key constraint as well.