Microsoft KB Archive/136536

{|
 * width="100%"|

FIX: SELECT INTO From Table w/ IDENTITY Col Causes Handled AV

 * }

Q136536

-

The information in this article applies to:


 * Microsoft SQL Server version 6.0

-

BUG# NT: 10340 (6.00)

SYMPTOMS
On Microsoft SQL Server version 6.0, a SELECT INTO from a table with an identity column when the set IDENTITY_INSERT option is ON can cause a handled access violation (AV).

The AV will not occur when the IDENTITY_INSERT option is switched OFF.

WORKAROUND

 * Set the IDENTITY_INSERT option OFF before performing the SELECT-INTO.

-OR-
 * Perform an INSERT by issuing a SELECT from the source to the destination table.

STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.0. This problem was corrected in Service Pack 2 for SQL Server version 6.0. For more information, contact your primary support provider.

Additional query words: sql6 windows nt

Keywords : kbprogramming

Issue type : kbbug

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600