FIX: AV When Selecting from View Based on Multiple Other Views in Compatibility Mode 70 (308837)

The information in this article applies to:

Microsoft SQL Server 2000 (all editions)

This article was previously published under Q308837

BUG #: 353902 (SHILOH_BUGS)

SYMPTOMS

When the database is set to compatibility level 70, a SELECT statement issued against a view that is built on multiple other views may result in the following error:

ODBC: Msg 0, Level 19, State 1 SqlDumpExceptionHandler: Process 51 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

An access violation (AV) will also be recorded in the SQL Server error log.

RESOLUTION

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:

290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack

WORKAROUND

Use the sp_dbcmptlevelet stored procedure to set the database compatibility level to 80.

STATUS

Microsoft has confirmed that this is a problem in Microsoft SQL Server 2000. This problem was first corrected in Microsoft SQL Server 2000 Service Pack 2.

MORE INFORMATION

You may see an access violation with lines that resemble the following sample short stack dump in the SQL Server error log (the exact text may vary depending on the build you are using):

0042EEDC Module(sqlservr+0002EEDC) (CValXVarTable::GetDataX(unsigned long *,class CXVariant *)+0000001F)
0042AB67 Module(sqlservr+0002AB67) (GetData(class CEsExec *,class CXVariant *)+00000019)
00416578 Module(sqlservr+00016578) (CEs::GeneralEval4(unsigned long *,class CEsExec *,class CXVariant *)+00000091)
0042C895 Module(sqlservr+0002C895) (CQScanNLJoin::GetRow(unsigned long *,unsigned long *)+00000161)

Modification Type:	Major	Last Reviewed:	10/16/2003
Keywords:	kbbug kbfix KB308837