FIX: Cannot Rename a Column With a Quoted Identifier

ID: Q153992


The information in this article applies to:


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          : kbnetwork SSrvGen kbbug6.50 kbfix6.50.sp1 
Version           : 6.5.201
Platform          : WINDOWS 
Issue type        : 

Last Reviewed: April 1, 1999