FIX: Error 15224 Renaming Column to 1 Character with Sp_rename (159816)


The information in this article applies to:

  • Microsoft SQL Server 6.5 Service Pack 1 and later
This article was previously published under Q159816
BUG #: 15750 (6.50: 0213)

SYMPTOMS

You receive the following parameter error when you attempt to use sp_rename to rename a column to a single character:
Msg 15224, Level 11, State 15
Error, the value for parameter NewName contains invalid characters or
violates a basic restriction ().

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 2 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider.

MORE INFORMATION

This problem only occurs with 6.50 with Service Pack 1 (build number 0213), not the Gold version of 6.50.
Modification Type:MajorLast Reviewed:10/3/2003
Keywords:kbBug kbfix kbusage KB159816
©2003 Microsoft Corporation. All rights reserved.