This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 236753 (shiloh_bugs)
During query compilation, SQL Server may encounter an exception access violation (AV) when the plan selection involves a complex Hash Match Team. The access violation will look similar to the following:
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 theMicrosoft Knowledge Base:
290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
NOTE: 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:
File name Platform ---------------------- S80217i.exe Intel
NOTE: Due to file dependencies, the most recent hotfix or feature that contains the above files may also contain additional files.
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.
The conditions required to encounter this situation occur rarely; it requires a significantly complex Hash Match Team query.
A key to this issue is that the exception is encountered during the compile phase. To determine whether you are encountering this issue, enable the 'set showplan_all on' option and execute the query. Because the error occurs during the compile phase, the exception is encountered before the showplan results are returned.