Article ID: 235693 - View products that this article applies to.
This article was previously published under Q235693
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 55981 (SQLBUG_70)
A handled access violation (AV) exception error occurs within a SELECT statement under the following conditions:
Short Stack Dump 0x006bdcab Module(sqlservr+2bdcab) (SDES::RepositionScan+39) 0x005911db Module(sqlservr+1911db) (RowsetSS::ReaquireLatchLong+b4) 0x00421775 Module(sqlservr+21775) (RowsetSS::GetData+42) 0x004ac022 Module(sqlservr+ac022) (CValSSTable::GetDataX+1c) 0x00630cc8 Module(sqlservr+230cc8) (CEs::FastCompare+7e) 0x00426876 Module(sqlservr+26876) (CDataBuffer::FGetPredicate+3a) 1999-06-23 12:20:31.87 spid9 CImageHelper::GetSym Error - The specified module could not be found.
The problem occurs when the execution plan performs a Hash Match without any sorting or ordering. The workaround is to apply either query hints or join hints that will create an execution plan that performs a sort or an order.
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. Microsoft has confirmed this to be a problem in SQL Server 2000.
(https://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