Microsoft KB Archive/254598

= BUG: Index Cannot be Dropped if the Name Begins with "#" Character =

Article ID: 254598

Article Last Modified on 10/16/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q254598



BUG #: 57433 (SQLBUG_70)



SYMPTOMS
An index with a name starting with the identifier '#' can not be dropped using the DROP INDEX statement. The following error message occurs when you try to drop such an index:

Server: Msg 159, Level 15, State 1, Line 1

For DROP INDEX, you must give both the table and the index name, in the form tablename.indexname.



WORKAROUND
The workaround is to rename the index using SP_RENAME and then drop it.

For example: sp_rename 'Categories.#index1','index1' go drop index Categories.index1 go



STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0.

Keywords: kbbug kbpending KB254598

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.