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

ID: 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          : kbprg SSrvProg SSrvTran_SQL kbbug6.00 kbfix6.00.sp2 
Version           : 6.0
Platform          : WINDOWS 
Issue type        :

Last Reviewed: April 20, 1999