This problem also occurs in Microsoft SQL Server 2005. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
Additional informationThe following sections include important information about the fix.
Steps to enable the fixIn SQL Server Configuration Manager, add the -T4128 startup parameter to the instance of SQL Server. To do this, follow these steps:
- In SQL Server Configuration Manager, click SQL Server Services.
- In the right pane, right-click SQL Server (instance_name), and then click Properties.
- In the Properties dialog box, click the Advanced tab.
- On the Advanced tab, locate the Startup Parameters item, and then type -T4128 at the end of the existing value.
Note Separate the parameter from other parameters by using a semicolon (;).
- Click OK, and then close SQL Server Configuration Manager.
- Restart the SQL Server 2008 database engine service for the trace flag to take effect.
Issues that the fix addressesThe fix addresses this issue when the following conditions are true:
- The user is updating by using a cursor. This can be identified from the Showplan by the UPDATE CURSOR operator.
- Before the execution of a Clustered Index Update statement, a Nested Loop statement is executed. This statement includes a cursor work table (CWT) that is used as a object, together with the Inner Join parameter. Then, the CWT object is used in the Clustered Index Statement as part of the execution plan for the node.
- There is an ORDER BY clause in the DECLARE CURSOR (or equivalent API) statement. You can only determine this with certainty by verifying the DECLARE CURSOR statement text.
For more information about the Incremental Servicing Model for SQL Server, click the following article number to view the article in the Microsoft Knowledge Base:
For more information about the naming schema for SQL Server updates, click the following article number to view the article in the Microsoft Knowledge Base:
For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
Article ID: 957872 - Last Review: Oct 15, 2008 - Revision: 1