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.