BUG: SQL-DMO Does Not Create an Identity Prop on Dec/Num Cols

ID: Q136859

The information in this article applies to:

Microsoft SQL Server version 6.0

SYMPTOMS

SQL Distributed Management Objects (SQL-DMO) do not create an identity property on a column defined as decimal or numeric type. The identity property can be chosen but is never set up. SQL Enterprise Manager (SEM) will display this problem because it uses SQL-DMO.

WORKAROUND

Write a CREATE TABLE command with the identity property and run it directly, or change the type of the column to int, smallint or tinyint.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 6.0. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: sql6 sem

Keywords : kbprg kbtool SSrvDMO SSrvEntMan SSrvProg kbbug6.00
Version : winnt:6.0
Platform : winnt
Issue type :