Microsoft KB Archive/105918

FIX: INSERT INTO a Temporary Table Can Cause GP Fault

PSS ID Number: Q105918 Article last modified on 10-31-1994

4.20

OS/2

BUG# OS/2: 1760 (4.2)

= SYMPTOMS =

An INSERT INTO a temporary table can cause SQL Server to general protection fault (GP fault).

= CAUSE =

The following circumstances are required in order to receive the GP fault:


 * The INSERT INTO the temporary table must be within a stored procedure.
 * You must be inserting into the temporary table using a SELECT statement that returns at least part of the temporary table in question.
 * It will only occur with specific datasets.

= STATUS =

Microsoft has confirmed this to be a problem in SQL Server version 4.2 for OS/2. This problem was corrected in SQL Server version 4.2aK11. For more information, contact your primary support provider.

Additional reference words: 4.20 KBCategory: kbprg kberrmsg KBSubCategory: SSrvServer SSrvGPF

=
================================================================

Copyright Microsoft Corporation 1994.