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 |