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


The information in this article applies to:

  • Microsoft SQL Server 6.5
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.
Modification Type:MajorLast Reviewed:10/3/2003
Keywords:kbBug kbpending KB189332
©2003 Microsoft Corporation. All rights reserved.