Microsoft KB Archive/308837

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

Article ID: 308837

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



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)

Additional query words: AV SP2 exception SqlDumpExceptionHandler convert coalesce CValXVarTable

Keywords: kbbug kbfix KB308837

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.