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,
Ken B. Matson
GCom2 Solutions