BUG: Unable to Create Table in Enterprise Manager After Deleting a Column with Description (278016)
The information in this article applies to:
- Microsoft SQL Server 2000 (all editions)
This article was previously published under Q278016
BUG #: 350792 (SHILOH)
SYMPTOMS
When you use the Table Designer to create a new table in SQL Enterprise Manager (SEM), if you give a column a Description and then delete the column, you may not be able to save the table. Instead, you may receive an error message that resembles the following:
'Table1' table
- Unable to create table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Object is
invalid. Extended properties are not permitted on 'dbo.Table1.cl1', or
the object does not exist.
WORKAROUND
After you receive this error, click Save change script to save a script that creates the table. Note, however, that the script will contain a command to create an extended property on the column that you deleted. This command will resemble the following:
DECLARE @v sql_variant
SET @v = N'test'
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'user', N'dbo', N'table', N'Table1', N'column', N'col2'
GO
To create the table, use a text editor to delete that command and then run the script.
STATUS
Microsoft has confirmed this to be a problem in SQL Server 2000.
| Modification Type: | Major | Last Reviewed: | 10/3/2003 |
|---|
| Keywords: | kbBug kbpending KB278016 |
|---|
|