No, no, no. I didn't mean delete from the system table. That's guaranted to stuff things up.
I meant drop the index.
DROP INDEX <TableName>.<IndexName>
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