FIX: Access Violation with Extra SELECT in Aggregate Function

• Microsoft SQL Server version 6.5
• Microsoft SQL Server, version 6.5 Service Pack 1

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          : kbusage SSrvErr_Log SSrvGPF kbbug6.50 kbbug6.50.sp1 kbfix6.50.sp2 
Version           : 6.5
Platform          : WINDOWS 
Issue type        : 

Last Reviewed: April 3, 1999