Microsoft KB Archive/139621

{|
 * width="100%"|

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