Article ID: 266368 - View products that this article applies to.
This article was previously published under Q266368
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 58090 (SQLBUG_70)
An UPDATE query that uses a LEFT OUTER JOIN may not complete until the user manually stops the query's execution. To determine if you are encountering this bug, examine the sysprocesses output for the UPDATE query's process ID (SPID) number. It should indicate a waittype of '0x0200', a lastwaittype of 'Exchange', and a status of 'sleeping'. In addition, the waittime should be increasing over time.
This situation may occur on a multiprocessor computer where parallelism is enabled and a parallel query plan has been chosen for the UPDATE query. The same conditions applied to a server with the original version of SQL Server 7.0 or SQL Server 7.0 SP1 do not encounter this bug.
To turn off parallelism, do one of the following:
(http://support.microsoft.com/kb/266372/EN-US/ )FIX: OPTION (MAXDOP 1) Hint May Not Turn Off Parallel Query
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.
(http://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 an UPDATE query that is affected by this bug: