FIX: Stored Procedure Unable to Access Temporary Table
  
PSS ID Number: Q113784
Article last modified on 10-31-1994
 
4.20bK12
 
OS/2
 

----------------------------------------------------------------------
The information in this article applies to:
 
  - Microsoft SQL Server version 4.2 for OS/2
----------------------------------------------------------------------
 
BUG# OS/2: 1818 (4.2bK12)
 
SYMPTOMS
========
 
When executing a stored procedure that attempts to access a temporary
table, the following error 208 is generated:
 
   Invalid object <#temp_table>
 
CAUSE
=====
 
The problem occurs when a stored procedure attempts to access a
temporary table that was created by the parent stored procedure.
The child stored procedure is unable to access the temporary object.
 
STATUS
======
 
Microsoft has confirmed this to be a problem in SQL Server version
4.2bk12 for OS/2. This problem was corrected in SQL Server version
4.2bK13. For more information, contact your primary support provider.
 
Additional reference words: 4.20 proc transact-SQL
KBCategory: kbprg
KBSubcategory: SSrvStProc SSrvServer
 
=============================================================================
 
Copyright Microsoft Corporation 1994.
