Microsoft KB Archive/189332

= BUG: Connection Broken for Remote Stored Procedure with Multiple COMPUTE BY Clauses =

Article ID: 189332

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q189332



BUG #: 17711 (SQLBUG_65)



SYMPTOMS
Execution of a remote stored procedure containing a SELECT statement with more than one COMPUTE BY clause (either a COMPUTE BY and a COMPUTE OR two COMPUTE BY clauses) returns the result for the first COMPUTE BY and then the connection stops responding. If the spid is killed, the following message is returned:

DB-Library: Possible network error: Error in sending out-of-band data

to SQL Server.

Net-Library error 232: ConnectionWrite (WriteFile).

DB-Library Process Dead - Connection Broken



WORKAROUND
To work around this problem, use a local stored procedure instead of a remote one.



STATUS
Microsoft has confirmed this to be a problem in SQL Server version 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: hang hangs hung

Keywords: kbbug kbpending KB189332

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.