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

SYMPTOMS

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.

STATUS

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:
http://www.microsoft.com/downloads/details.aspx?familyid=F62F45E9-24ED-4FA6-BD74-8A26606F96D8

Properties

Article ID: 274354 - Last Review: February 28, 2014 - Revision: 5.1
APPLIES TO
  • Microsoft SQL Server 7.0 Service Pack 1
  • Microsoft SQL Server 7.0 Service Pack 2
Keywords: 
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 smallbusiness.support.microsoft.com