Microsoft KB Archive/110564

From BetaArchive Wiki

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.