Microsoft distributes SQL Server 2000 fixes as one downloadable file. Because the fixes are cumulative, each new release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2000 fix release.
When you try to run a complex query that includes multiple correlated subqueries and the subqueries use a self-join, you may not be able to run the query successfully. You may also receive the following error message:
Server: Msg 8623, Level 16, State 1, Line 1 Internal Query Processor Error: The query processor could not produce a query plan. Contact your primary support provider for more information.
You may also notice similar behavior when you try to run a merge replication agent for a merge publication that has dynamic filtering enabled.
Service pack information
To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
290211 How to obtain the latest SQL Server 2000 service pack
The English version of this fix has the file attributes (or later) that are listed in the following table. The dates and times for these files are listed in coordinated universal time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.
Note Because of file dependencies, the most recent hotfix or feature that contains these files may also contain additional files.
To work around this problem, use the FORCE ORDER query hint to force the join order. However, if you force the join order, the query optimizer may not generate the optimal query plan, and you may experience slow query performance.
For more information about how to use the FORCE ORDER query hint, see the "OPTION Clause" topic in SQL Server Books Online.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
This problem was first corrected in Microsoft SQL Server 2000 Service Pack 4.
For additional information about an 8623 error message, click the following article numbers to view the articles in the Microsoft Knowledge Base:
302825 FIX: Complex join query with views and redundant tables may cause error 8623
818729 FIX: Internal query processor error 8623 when Microsoft SQL Server tries to compile a plan for a complex query
826815 FIX: You receive an 8623 error message in SQL Server when you try to run a query that has multiple correlated subqueries
For additional information about software updates, click the following article number to view the article in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates