FIX: Cannot Rename a Column With a Quoted Identifier (153992)
The information in this article applies to:
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.
| Modification Type: | Minor | Last Reviewed: | 3/16/2005 |
|---|
| Keywords: | kbBug kbfix kbnetwork KB153992 |
|---|
|