Microsoft KB Archive/139621

From BetaArchive Wiki

BUG: SQL-DMO Scripting Does Not Add Identity Property

Q139621



The information in this article applies to:


  • Microsoft SQL Server version 6.0



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.