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
 

----------------------------------------------------------------------
The information in this article applies to:
 
  - Microsoft SQL Server version 4.2 for 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.
