Article ID: 278698 - View products that this article applies to.
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:
0056701F Module(sqlservr+0016701F) (CBndOutputs::RemapValrefs(class CRemapContext *,int)+0000000A)
00703A1C Module(sqlservr+00303A1C) (CXteHashMatch::CreateInputScan(class IMemObj *,class CVRTable...
004A8B35 Module(sqlservr+000A8B35) (CXteHashMatch::CreateBailoutPlan(class CRemapContext *,class ...
004A70B6 Module(sqlservr+000A70B6) (CXteHashMatch::IntermediateCompile...
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:
(https://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 above files may also contain additional files.
File name Platform ---------------------- S80217i.exe Intel
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.