nate (11/26/2008)
Gail, the quick response is much appreciated. Also, nice presentation at PASS 2008.
Oh, thanks.
The primary key is actually non-clustered, and I'm trying to delete a clustered index that's on the same column as the PK.
Foreign keys are enforced from the pk or from a unique constraint, not from plain indexes.
What's the output of sp_helpindex on that table?
What's the exact error you get if you try to run a drop index on that clustered index
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability