InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 17:33:49 GMT20http://www.sqlservercentral.com/Forums/Topic9330-101-1.aspx--- 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!!!??? Thu, 16 Jan 2003 06:15:00 GMTjpipes