Knowledge Base

FIX: Access Violation with Extra SELECT in Aggregate Function

Article ID: 156680

Article Last Modified on 10/3/2003

Microsoft SQL Server 6.5 Standard Edition
Microsoft SQL Server 6.5 Service Pack 1

This article was previously published under Q156680

BUG #: 15979 (SQL 6.5)

SYMPTOMS

The extra SELECT keyword in the selection list of an aggregate function may cause a thread level access violation, and result in the following error message:

This command did not return data, and it did not return any rows.
DB-Library Process Dead - Connection Broken.

WORKAROUND

To work around this problem, remove the extra SELECT keyword.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server 6.5. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider.

Additional query words: av

Keywords: kbbug kbfix kbusage KB156680