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