BUG: SQL-DMO Scripting Does Not Add Identity Property

Q139621


The information in this article applies to:

BUG# NT: 11937 (6.00)

SYMPTOMS

The Generate Scripts option of SQL-DMO (which is used by SQL Enterprise Manager) will not create the identity property on a table that does have an IDENTITY column.


RESOLUTION

You can either generate the script with the 'Table DRI' option; modify the script generated by SQL-DMO to add the identity property; or keep the script the table was created with.


STATUS

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

Additional query words: sql6 generate enterprise sem

Keywords : kbtool kbusage
Issue type : kbbug
Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600


Last Reviewed: March 11, 2000
© 2001 Microsoft Corporation. All rights reserved. Terms of Use.