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

This article has been archived. It is offered "as is" and will no longer be updated.
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.
Properties

Article ID: 812250 - Last Review: 02/27/2014 21:16:24 - Revision: 4.4

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, Workgroup Edition, Microsoft SQL Server 2000 Desktop Engine (Windows), Microsoft SQL Server 2000 Enterprise Edition 64-bit

  • kbnosurvey kbarchive kbhotfixserver kbqfe kbqfe kbsqlserv2000presp4fix kbfix kbbug KB812250
Feedback