Hi,

How can I explicitely delete one of SQL Servers "auto created" indexes? It's easy enough to find it in the sysindexes table, but trying to delete it by name with "drop index" yields a

Cannot drop the index '_WA......', because it does not exist in the system catalog.

message.

So - how can I delete it? Does just removing it from sysindexes "delete" the actual index? Will SQL server eventually remove it itself once I have a 'real' index in place that serves the same purpose?

TIA,