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
Last Reviewed: March 30, 2000 |