Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Index won't drop !!! Expand / Collapse
Author
Message
Posted Thursday, January 16, 2003 6:15 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Tuesday, October 21, 2003 12:00 AM
Points: 728, Visits: 1
--- Anyone ever seen this??? ---
I created an index with a pound sign as the first character, thinking to designate as a temporary index. I was only using this index for some perfomance testing. Anyway, when I was done with the index, I tried dropping it, using the index name. Didn't work. Said unrecognized object name... Tried putting square brackets around the name. Same thing... Tried double quotes. Same thing... I looked in Enterprise Manager, and sure enough, there was my new (now not so temporary) index tied to my table. Tried dropping it through Enterprise Manager. Same error in a dialog box. I even went to the system tables and found the object, but it refused to let me delete the index, even after updating options to allow editing systables...

What happened!!!???




Post #9330
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse