FIX: Stored Procedure May Cause Out of Sync Error
  
PSS ID Number: Q110564
Article last modified on 07-25-1995
 
4.20
 
WINDOWS
 

----------------------------------------------------------------------
The information in this article applies to:
 
 - Microsoft SQL Server, version 4.2
----------------------------------------------------------------------
 
BUG# NT: 590 (4.2)
 
SYMPTOMS
========
 
A client executing a stored procedure may receive the error
 
   Datastream processing out of sync
 
in some specific circumstances with Microsoft SQL Server.
 
STATUS
======
 
Microsoft has confirmed this to be a problem in Microsoft SQL Server
version 4.2. This problem was corrected in Microsoft SQL Server version
4.21.
 
MORE INFORMATION
================
 
If a temporary table is created and loaded inside a stored procedure and
then updated, this may cause the error by selecting data from the table
after the update. This will only occur in rare circumstances.
 
Additional reference words: 4.20 kernel datastream sync Windows NT
KBCategory: kbprg kbbug4.20 kbfix4.21
KBSubcategory: SSrvWinNT
 
=============================================================================
 
Copyright Microsoft Corporation 1995.
