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)
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: