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:
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