Article ID: 276329 - View products that this article applies to.
This article was previously published under Q276329
BUG #: 236325 (SHILOH_BUGS)
If all of the following conditions are true about a complex query, it is possible to receive unexpected results:
To resolve this problem, obtain the latest service pack for Microsoft 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
HotfixNOTE: The following hotfix was created prior to Microsoft SQL Server 2000 Service Pack 1.
The English version of this fix should have the following file attributes or later:
NOTE: Due to file dependencies, the most recent hotfix or feature that contains the preceding files may also contain additional files.
File name Platform -------------------- s80211i.exe x86
Prevent either the query or SQL Server from using the parallel execution plans by using either the MAXDOP 1 hint on the query or by changing the max degree of parallelism sp_configure setting to the value 1.
Microsoft has confirmed that this is a problem in Microsoft SQL Server 2000. This problem was first corrected in SQL Server 2000 Service Pack 1.