Microsoft KB Archive/138262

{|
 * width="100%"|

BUG: CREATE TABLE w/ IDENTITY Property May Cause Client AV

 * }

Q138262

-

The information in this article applies to:


 * Microsoft SQL Server version 6.0

-

BUG# NT: 11573 (6.00)

SYMPTOMS
A CREATE TABLE statement which includes a column bound by an identity property may cause a client access violation if the seed for the identity property is specified via a variable or the increment is specified via a variable.

WORKAROUND
Assign constants for the seed and increment when using the identity property.

STATUS
Microsoft has confirmed this to be a problem in Microsoft 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 windows nt

Keywords : kbprogramming

Issue type :

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600