Article ID: 199763
Article Last Modified on 7/19/2006
APPLIES TO
- Microsoft SQL Server 7.0 Standard Edition
- Microsoft SQL Server 6.5 Standard Edition
This article was previously published under Q199763
BUG #: 17190 (SQLBUG_65)
SYMPTOMS
Client applications might stop responding when using a cursor to process the results from a stored procedure that has multiple aggregate functions in its select list as well as in its where clause.
WORKAROUND
To work around this problem:
- Do not use cursors against the stored procedure.
-or-
- Divide the stored procedure into smaller procedures.
STATUS
Microsoft has confirmed this to be a problem in SQL Server 6.50.201. This problem has been corrected in U.S. Service Pack 5 for Microsoft SQL Server 6.50.201. For information about how to download and install the latest SQL Server Service Pack, see the following Microsoft Web site:
For more information, contact your primary support provider.
Keywords: kbbug kbcodesnippet kbfix KB199763