Microsoft KB Archive/136859

{|
 * width="100%"|

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

 * }

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.

Additional query words: sql6 sem

Keywords : kbprogramming kbtool

Issue type : kbbug

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600