Dump file

Hi Everyone,
We have a SQL Server creates a dump file & stops the
service. Any help is highly appeciated.
SQL 2000 (SP3A) on a Windows 2000 Box (SP4)
Thanks,
========================================
===================
==========
BugCheck
Dump
========================================
===================
==========
This file is generated by Microsoft SQL Server
8.00.760
upon detection of fatal unexpected error. Please return
this file,
the query or program that produced the bugcheck, the
database and
the error log, and any other pertinent information with a
Service Request.
Computer type is AT/AT
COMPATIBLE.
Bios Version is PhoenixBIOS 4.0 Release
6.0
Current time is 13:27:01
06/18/04.
4 Intel x86 level 15, 3066 Mhz processor
(s).
Windows NT 5.0 Build 2195 CSD Service Pack
4.
Memory
MemoryLoad = 77%
Total Physical = 2046 MB
Available Physical = 465 MB
Total Page File = 3940 MB
Available Page File = 2463 MB
Total Virtual = 2047 MB
Available Virtual = 288 MB
*Dump thread - spid = 68, PSS = 0x52f031c8, EC =
0x52f034f0
*Stack Dump being sent to d:\Microsoft SQL
Server\MSSQL\log\SQLDump0001.txt
*
****************************************
*******************
******************
**
*
* BEGIN STACK
DUMP:
* 06/18/04 13:27:01 spid
68
*
*
*
* Input Buffer 224 bytes -
* CREATE UNIQUE CLUSTERED INDEX [PK_promo] ON [dbo].
[promo] ([promo_id]
* ) WITH DROP_EXISTING ON
[PRIMARY]
*
*
* MODULE BASE END
SIZE
* sqlservr 00400000 00B2CFFF
0072d000
* ntdll 77F80000 77FFAFFF
0007b000
* KERNEL32 7C570000 7C622FFF
000b3000
* ADVAPI32 7C2D0000 7C331FFF
00062000
* RPCRT4 77D30000 77D9DFFF
0006e000
* USER32 77E10000 77E6EFFF
0005f000
* GDI32 77F40000 77F78FFF
00039000
* OPENDS60 41060000 41065FFF
00006000
* MSVCRT 78000000 78044FFF
00045000
* UMS 41070000 4107CFFF
0000d000
* SQLSORT 42AE0000 42B6FFFF
00090000
* MSVCIRT 780A0000 780B1FFF
00012000
* sqlevn70 41080000 41086FFF
00007000
* NETAPI32 027A0000 027EEFFF
0004f000
* SECUR32 027F0000 027FEFFF
0000f000
* NETRAP 02800000 02805FFF
00006000
* SAMLIB 02810000 0281EFFF
0000f000
* WS2_32 02820000 02833FFF
00014000
* WS2HELP 02840000 02847FFF
00008000
* WLDAP32 02850000 02879FFF
0002a000
* DNSAPI 02880000 028A3FFF
00024000
* WSOCK32 028B0000 028B7FFF
00008000
* ole32 02CA0000 02D8BFFF
000ec000
* XOLEHLP 02E10000 02E17FFF
00008000
* MSDTCPRX 02E20000 02ED3FFF
000b4000
* MTXCLU 02EE0000 02EEFFFF
00010000
* VERSION 02EF0000 02EF6FFF
00007000
* LZ32 02F00000 02F05FFF
00006000
* CLUSAPI 02F10000 02F1FFFF
00010000
* RESUTILS 02F20000 02F2CFFF
0000d000
* USERENV 02F30000 02F90FFF
00061000
* rnr20 02FA0000 02FABFFF
0000c000
* iphlpapi 02FF0000 03002FFF
00013000
* ICMP 03010000 03014FFF
00005000
* MPRAPI 03020000 03036FFF
00017000
* OLEAUT32 03040000 030DAFFF
0009b000
* ACTIVEDS 030E0000 0310EFFF
0002f000
* ADSLDPC 03110000 03132FFF
00023000
* RTUTILS 03140000 0314DFFF
0000e000
* SETUPAPI 03150000 031DDFFF
0008e000
* RASAPI32 031E0000 03212FFF
00033000
* RASMAN 03220000 03230FFF
00011000
* TAPI32 03240000 03261FFF
00022000
* COMCTL32 03270000 032F3FFF
00084000
* SHLWAPI 03300000 03364FFF
00065000
* DHCPCSVC 03370000 03388FFF
00019000
* winrnr 03830000 03837FFF
00008000
* rasadhlp 03840000 03844FFF
00005000
* SSNMPN70 03F40000 03F45FFF
00006000
* SSNETLIB 03F50000 03F64FFF
00015000
* security 042A0000 042A3FFF
00004000
* msafd 04B90000 04BADFFF
0001e000
* wshtcpip 04C00000 04C06FFF
00007000
* SSmsLPCn 04CA0000 04CA6FFF
00007000
* ntdsapi 04D80000 04D90FFF
00011000
* SQLFTQRY 063E0000 06411FFF
00032000
* CLBCATQ 06420000 064A5FFF
00086000
* sqloledb 064C0000 06532FFF
00073000
* MSDART 06540000 0655EFFF
0001f000
* comdlg32 06560000 0659DFFF
0003e000
* SHELL32 06630000 06877FFF
00248000
* MSDATL3 06880000 06894FFF
00015000
* oledb32 06D30000 06D95FFF
00066000
* OLEDB32R 06DA0000 06DAFFFF
00010000
* msv1_0 06DB0000 06DCEFFF
0001f000
* CRYPT32 06DD0000 06E47FFF
00078000
* MSASN1 06E50000 06E5FFFF
00010000
* xpsqlbot 06E60000 06E65FFF
00006000
* rsabase 07010000 07032FFF
00023000
* xpstar 08830000 08876FFF
00047000
* SQLRESLD 08880000 08886FFF
00007000
* SQLSVC 08890000 088A6FFF
00017000
* ODBC32 088B0000 088E1FFF
00032000
* odbcbcp 088F0000 088F5FFF
00006000
* W95SCM 08900000 0890BFFF
0000c000
* SQLUNIRL 10000000 1002CFFF
0002d000
* WINSPOOL 08910000 0892DFFF
0001e000
* MPR 08930000 08940FFF
00011000
* SHFOLDER 08950000 08957FFF
00008000
* odbcint 08B20000 08B35FFF
00016000
* NDDEAPI 08B40000 08B46FFF
00007000
* SQLSVC 08B50000 08B55FFF
00006000
* xpstar 08B60000 08B68FFF
00009000
* mswsock 08EF0000 08F01FFF
00012000
* xplog70 09960000 09971FFF
00012000
* xplog70 09980000 09983FFF
00004000
* dbghelp 06E90000 06F44FFF
000b5000
*
ec_buftrace.Entry [62]
--
bpage = 0x1A010000 bhash = 0x00000000
bpageno = (1:744605)
bdbid = 59 breferences = 8336 bstat
= 0xb
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [63]
--
bpage = 0x42F52000 bhash = 0x00000000
bpageno = (1:849240)
bdbid = 59 breferences = 1406 bstat
= 0xb
bspin = 0 bnext = 0x00000000
EXCEPT (null) @.0x0DCEC148
--
exc_number = 0 exc_severity =
0
exc_func = MSQLErrorHandler+0 Line 0+0x0Under what circumstances do you see this? Also could you please paste the
"short stack dump" that is present in the error logs.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.