Knowledge Base

FIX: Indexed View May Cause a Handled Access Violation in CIndex::SetLevel1Names

Article ID: 812250

Article Last Modified on 11/2/2007

APPLIES TO

Microsoft SQL Server 2000 Developer Edition
Microsoft SQL Server 2000 Standard Edition
Microsoft SQL Server 2000 Enterprise Edition
Microsoft SQL Server 2000 Personal Edition
Microsoft SQL Server 2000 Enterprise Edition
Microsoft SQL Server 2000 Workgroup Edition
Microsoft SQL Server 2000 Desktop Engine (Windows)
Microsoft SQL Server 2000 Developer Edition
Microsoft SQL Server 2000 Enterprise Edition 64-bit

BUG #: 363713 (SHILOH_BUGS)

SYMPTOMS

A query based on an indexed view may cause a handled access violation exception in the CIndex::SetLevel1Names function and end the connection of the client
that submitted the query. Additionally, messages similar to the following are written
to the SQL Server error log:

2002-12-30 13:17:01.99 spid51 Using 'dbghelp.dll' version '4.0.5'

Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL\log\SQL00001.dmp

2002-12-30 13:17:01.99 spid51 Error: 0, Severity: 19, State: 0
2002-12-30 13:17:01.99 spid51 SqlDumpExceptionHandler: Process 51 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process..

RESOLUTION

Service pack information

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 How to obtain the latest SQL Server 2000 service pack

Hotfix information

The English version of this fix has the file attributes (or later) that are listed in the following table. The dates and times for these files are listed in coordinated universal time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.

   Date         Time   Version         Size              File name
   -------------------------------------------------------------------------

   17-Jan-2002  20:45  2000.80.568.0      29,244 bytes   Dbmslpcn.dll
   30-Aug-2002  13:08                    786,432 bytes   Distmdl.ldf
   30-Aug-2002  13:08                  2,359,296 bytes   Distmdl.mdf
   11-Dec-2002  09:50                        180 bytes   Drop_repl_hotfix.sql
   02-Jul-2002  07:35  2000.80.650.0     107,088 bytes   Impprov.dll
   11-Dec-2002  09:50                      1,402 bytes   Inst_repl_hotfix.sql
   19-Jul-2002  08:56                    774,516 bytes   Instdist.sql
   20-Aug-2002  08:24  2000.80.679.0     111,172 bytes   Logread.exe
   15-Dec-2002  15:21  2000.80.717.0      90,692 bytes   Msgprox.dll
   06-Apr-2002  18:08  2000.80.606.0      62,024 bytes   Odsole70.dll
   02-Jan-2002  17:59                     18,185 bytes   Qfe356326.sql
   20-Aug-2002  08:47  2000.80.679.0     135,748 bytes   Qrdrsvc.exe
   26-Aug-2002  14:49  2000.80.679.0     406,088 bytes   Rdistcom.dll
   03-Oct-2001  17:36                    437,302 bytes   Replcom.sql
   20-Aug-2002  08:33  2000.80.679.0     152,136 bytes   Replmerg.exe
   25-Nov-2002  13:43                  1,004,990 bytes   Replmerg.sql
   15-Dec-2002  15:21  2000.80.717.0     221,768 bytes   Replprov.dll
   15-Dec-2002  15:21  2000.80.717.0     303,688 bytes   Replrec.dll
   03-Oct-2001  17:36                    986,906 bytes   Replsys.sql
   03-Oct-2001  17:36                    881,228 bytes   Repltran.sql
   26-Aug-2002  14:49  2000.80.679.0     283,208 bytes   Rinitcom.dll
   16-Sep-2002  14:31                    390,045 bytes   Securityhotfix.sql
   26-Aug-2002  14:49  2000.80.679.0      28,672 bytes   Sqlagent.dll
   26-Aug-2002  10:39  2000.80.679.0     311,872 bytes   Sqlagent.exe
   28-Aug-2002  08:32  2000.80.679.0      49,152 bytes   Sqlagent.rll
   26-Aug-2002  14:49  2000.80.679.0      53,824 bytes   Sqlcmdss.dll
   28-Aug-2002  08:40  2000.80.679.0      12,288 bytes   Sqlcmdss.rll
   24-Oct-2002  09:37  2000.80.695.0     176,696 bytes   Sqlmap70.dll
   27-Dec-2002  21:39  2000.80.721.0   7,471,185 bytes   Sqlservr.exe
   01-Nov-2002  10:56  2000.80.698.0      45,644 bytes   Sqlvdi.dll
   17-Jan-2002  20:45  2000.80.568.0      29,244 bytes   Ssmslpcn.dll
   19-Dec-2002  16:55  2000.80.719.0      82,492 bytes   Ssnetlib.dll
   19-Dec-2002  18:09  2000.80.720.0      25,148 bytes   Ssnmpn70.dll
   06-Apr-2002  18:08  2000.80.606.0      70,208 bytes   Xplog70.dll
   06-Apr-2002  18:08  2000.80.606.0      53,828 bytes   Xpqueue.dll
   06-Apr-2002  18:08  2000.80.606.0     156,228 bytes   Xprepl.dll
   11-Jul-2002  17:00  2000.80.658.0     279,104 bytes   Xpstar.dll
   16-Sep-2002  15:12  2000.80.686.0      98,872 bytes   Xpweb70.dll

NOTE: Because of file dependencies, the most recent hotfix or feature that contains the files may also contain additional files.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.This problem was first corrected in Microsoft SQL Server 2000 Service Pack 4.

Keywords: kbbug kbfix kbqfe kbsqlserv2000presp4fix kbhotfixserver KB812250

Microsoft KB Archive/812250

Contents