FIX: Cannot Rename a Column With a Quoted Identifier
Article ID: 153992
Article Last Modified on 3/16/2005
APPLIES TO
- Microsoft SQL Server 6.5 Standard Edition
This article was previously published under Q153992
SYMPTOMS
If you try to rename a table's column to use a quoted identifier column
name, sp_rename gives an error indicating that the column name is invalid.
The errors are as folows:
Msg 15006, Level 16, State 1
'<column name>' is not a valid name since it contains invalid characters
Msg 15224, Level 11, State 1
Error, the value for parameter NewName contains invalid characters or
violates a basic restriction
WORKAROUND
Export the data. Drop and re-create the table with quoted identifiers on
necessary columns. Import the data back in.
STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server
version 6.5. This problem has been corrected in U.S. Service Pack 1 for
Microsoft SQL Server version 6.5. For more information, contact your
primary support provider.
Additional query words: sp1
Keywords: kbbug kbfix kbnetwork KB153992