LouBurgoyne
MIS
I have run sp_helpindex 'TableName' on a table in a production database. It returns over 20 indexes with a description of "nonclustered, statistics, auto create located on PRIMARY"
These indexes cannot be dropped. "Drop Index TableName.IndexName produces "does not exist in the system catalog".
Questions:
1. Where are these indexes coming from?
2. Are they important?
Thanks
Lou Burgoyne
These indexes cannot be dropped. "Drop Index TableName.IndexName produces "does not exist in the system catalog".
Questions:
1. Where are these indexes coming from?
2. Are they important?
Thanks
Lou Burgoyne