BUG: Table Designer Gives an Error with Quotes in a Column Name

ID: Q197798


The information in this article applies to:

BUG #: 41942 (SQLBUG_70)

SYMPTOMS

When designing a table in Enterprise Manager, you may receive the following error message:

The name <string> is invalid because it is empty, contains invalid
characters, or is too long.


CAUSE

This error occurs when you try to create a column name that includes a single quotation mark. This can occur either when you create a new table or rename a column in an existing table. The error occurs even if the column name is delimited with square brackets.


WORKAROUND

To work around this problem, try one of the following:


STATUS

Microsoft has confirmed this to be a problem in SQL Server version 7.0.

Additional query words: Design Table Designer MMC SEM err msg quote


Keywords          : SSrvEntMan kbbug7.00 
Version           : WINNT:7.0
Platform          : winnt 
Issue type        : kbbug 

Last Reviewed: April 19, 1999