FIX: Client Apps Stop Responding When Running Server-Side Cursors Against Stored Procedures (199763)
The information in this article applies to:
- Microsoft SQL Server 7.0
- Microsoft SQL Server 6.5
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.
| Modification Type: | Major | Last Reviewed: | 7/19/2006 |
|---|
| Keywords: | kbBug kbCodeSnippet kbfix KB199763 |
|---|
|