Microsoft KB Archive/110564

FIX: Stored Procedure May Cause Out of Sync Error

PSS ID Number: Q110564 Article last modified on 07-25-1995

4.20

WINDOWS

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.