Microsoft KB Archive/254598

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Knowledge Base


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