Article ID: 266372 - View products that this article applies to.
This article was previously published under Q266372
BUG #: 58092 (SQLBUG_70)
A complex UPDATE statement using the OPTION (MAXDOP 1) hint on multiprocessor computers may not turn off parallel query plan.
To turn off parallelism, do one of the following:
Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
274799For more information, contact your primary support provider.
(https://support.microsoft.com/kb/274799/ )INF: How to Obtain Service Pack 3 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0
The following is an example of the complex UPDATE query reported in this bug:
Article ID: 266372 - Last Review: March 14, 2006 - Revision: 2.1