Microsoft KB Archive/199763

= FIX: Client Apps Stop Responding When Running Server-Side Cursors Against Stored Procedures =

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:

http://www.microsoft.com/sql/prodinfo/previousversions/downloads/servicepacks.mspx

For more information, contact your primary support provider.

Keywords: kbbug kbcodesnippet kbfix KB199763

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.