FIX: FAST_FORWARD Cursors Perform Slower

Article translations Article translations
Article ID: 274354 - View products that this article applies to.
This article was previously published under Q274354
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 57131 (SQLBUG_70)
Expand all | Collapse all


FAST_FORWARD cursors are twice as slow on SQL Server 7.0 Service Pack 1 (SP1) and Service Pack 2 (SP2) as compared to Microsoft SQL Server 7.0 without any service packs.


Microsoft has confirmed this to be a problem in SQL Server 7.0 with Service Pack 1 or Service Pack 2 installed.

The same operation works fine in pre-sp1 builds.

This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server version 7.0. For information about downloading and installing the latest SQL Server Service Pack, see the following Web address:


Article ID: 274354 - Last Review: February 28, 2014 - Revision: 5.1
  • Microsoft SQL Server 7.0 Service Pack 1
  • Microsoft SQL Server 7.0 Service Pack 2
kbnosurvey kbarchive kbbug kbfix KB274354

Give Feedback


Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from