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.