Hi all,

I am in the process of optimizing a SQL database and there are alot of auto
generated indexes that I would like to remove. They start with _WA_Sys_...

I tried executing a
DROP INDEX AcctsRec._WA_Sys_ARAmt_75D7831F
GO
but it gives me this error:
Server: Msg 3703, Level 11, State 7, Line 1
Cannot drop the index 'AcctsRec._WA_Sys_ARAmt_75D7831F', because it does not
exist in the system catalog.

I queried the sysindexes table and the record exists for this index and when
I look at the Taskpad view for the database, the index shows up.

So, my question is, how (if possible) can I remove this index? I want to
remove all of these indexes and then see if they get regenerated as part of
my optimization process.

Thanks,
Greg


MS Sql Server LazyDBA home page