FIX: FAST_FORWARD Cursors Perform Slower

View products that this article applies to.

This article was previously published under Q274354

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.

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