Microsoft KB Archive/278016

= BUG: Unable to Create Table in Enterprise Manager After Deleting a Column with Description =

Article ID: 278016

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



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.

Keywords: kbbug kbpending KB278016

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.