Article ID: 282982 - View products that this article applies to.
This article was previously published under Q282982
BUG #: 351566 (SHILOH_bugs)
Using a cursor to update a table may result in a long execution time under the following circumstances:
To resolve this problem, obtain the latest service pack for SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/290211/EN-US/ )INF: How to Obtain the Latest SQL Server 2000 Service Pack
Any of the following changes will reduce the changes of encountering the problem:
Microsoft has confirmed that this is a problem in SQL Server 2000. This problem was first corrected in SQL Server 2000 Service Pack 1.