BUG: Client Apps Stop Responding When Running Server-side Cursors Against Stored Procedures

ID: Q199763

The information in this article applies to:

Microsoft SQL Server version 6.5

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 version 6.50.201. This problem has been corrected in U.S. Service Pack 5 for Microsoft SQL Server version 6.50.201. For information about downloading and installing the latest SQL Server Service Pack, see http://support.microsoft.com/support/sql/.

For more information, contact your primary support provider.

Additional query words:

Keywords : SSrvProg SSrvStProc kbbug6.50 kbSQLServ650bug kbCodeSnippet
Version : winnt:6.5
Platform : winnt
Issue type : kbbug