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

ID: Q136859

• 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           : 6.0
Platform          : WINDOWS

Last Reviewed: May 2, 1997