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

• Microsoft SQL Server version 6.5

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