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

ID: Q189332

The information in this article applies to:
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          : SSrvStProc SSrvTran_SQL kbbug6.50 
Version           : WINNT:6.5
Platform          : winnt 
Issue type        : kbbug

Last Reviewed: April 16, 1999