July 28, 2006 at 1:23 pm
I found today, after executing the IndexReport script (found on this website!!), that, due to a bug in the Microsoft Index Tuning Wizard, I have a lot of Hypothetical Indexes left around in one of my databases.
After doing to research I found that Micorsoft has a script which should identify and remove these indexes (http://support.microsoft.com/kb/q293177/) - Great!!!
Unfortunately when I execute the script I get the following error message for each attempt to drop the HI:
Cannot drop the index 'tablename.hind_xyz', because it does not exist in the system catalog.
Can someone explain this error/problem???
Thanks
Glenn
July 31, 2006 at 5:44 am
yeah I'm not sure they are indexes .. try drop statistics .. I'd normally delete direct from the system table .. but you might not feel safe with this approach.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply