Jun 6, 2008
I have a one database that appears to have some corruption but being new to SQL 2005 I can't seem to find the problem, only a bunch of stack dumps and DBCC doesn't appear to return the results I would expect.
DBCC CHECKDB (MYDB) WITH ALL_ERRORMSGS, NO-INFOMSGS
Msg 211, Level 23, State 51, Line 2
Possible schema corruption. Ru DBCC CheckCatalog.
Msg 0, level 20, State 0, line 0
A severe error occurred on the current command. The results should be discard
DBCC CHECKCATALOG (MYDB)
DBCC execution completed. If DBCC printed error messages, contact your system administrator
Stack Dump
06/06/2008 08:45:58,spid187,Unknown,External dump process return code 0x20000001.<nl/>External dump process returned no errors.
06/06/2008 08:45:56,spid187,Unknown,Stack Signature for the dump is 0x4E678B02
06/06/2008 08:45:56,spid187,Unknown,* -------------------------------------------------------------------------------
06/06/2008 08:45:56,spid187,Unknown,78132A47 Module(MSVCR80+00002A47)
06/06/2008 08:45:56,spid187,Unknown,781329BB Module(MSVCR80+000029BB)
06/06/2008 08:45:56,spid187,Unknown,010B9201 Module(sqlservr+000B9201)
06/06/2008 08:45:56,spid187,Unknown,010B9064 Module(sqlservr+000B9064)
06/06/2008 08:45:56,spid187,Unknown,010B939C Module(sqlservr+000B939C)
06/06/2008 08:45:56,spid187,Unknown,010B94A5 Module(sqlservr+000B94A5)
06/06/2008 08:45:56,spid187,Unknown,010075DC Module(sqlservr+000075DC)
06/06/2008 08:45:56,spid187,Unknown,010078CC Module(sqlservr+000078CC)
06/06/2008 08:45:56,spid187,Unknown,010077A6 Module(sqlservr+000077A6)
06/06/2008 08:45:56,spid187,Unknown,0102F1F4 Module(sqlservr+0002F1F4)
06/06/2008 08:45:56,spid187,Unknown,01032A36 Module(sqlservr+00032A36)
06/06/2008 08:45:56,spid187,Unknown,01028600 Module(sqlservr+00028600)
06/06/2008 08:45:56,spid187,Unknown,0134752A Module(sqlservr+0034752A)
06/06/2008 08:45:56,spid187,Unknown,01430633 Module(sqlservr+00430633)
06/06/2008 08:45:56,spid187,Unknown,01346B6B Module(sqlservr+00346B6B)
06/06/2008 08:45:56,spid187,Unknown,013A929A Module(sqlservr+003A929A)
06/06/2008 08:45:56,spid187,Unknown,01368BB2 Module(sqlservr+00368BB2)
06/06/2008 08:45:56,spid187,Unknown,013A9BDC Module(sqlservr+003A9BDC)
06/06/2008 08:45:56,spid187,Unknown,013A9A04 Module(sqlservr+003A9A04)
06/06/2008 08:45:56,spid187,Unknown,0131F5C0 Module(sqlservr+0031F5C0)
06/06/2008 08:45:56,spid187,Unknown,013A9A04 Module(sqlservr+003A9A04)
06/06/2008 08:45:56,spid187,Unknown,0131F721 Module(sqlservr+0031F721)
06/06/2008 08:45:56,spid187,Unknown,01320085 Module(sqlservr+00320085)
06/06/2008 08:45:56,spid187,Unknown,013A9A04 Module(sqlservr+003A9A04)
06/06/2008 08:45:56,spid187,Unknown,01369B63 Module(sqlservr+00369B63)
06/06/2008 08:45:56,spid187,Unknown,0136A2D8 Module(sqlservr+0036A2D8)
06/06/2008 08:45:56,spid187,Unknown,0136A1B4 Module(sqlservr+0036A1B4)
06/06/2008 08:45:56,spid187,Unknown,0136A071 Module(sqlservr+0036A071)
06/06/2008 08:45:56,spid187,Unknown,013AD9F3 Module(sqlservr+003AD9F3)
06/06/2008 08:45:56,spid187,Unknown,013AD7EB Module(sqlservr+003AD7EB)
06/06/2008 08:45:56,spid187,Unknown,013AD6FB Module(sqlservr+003AD6FB)
06/06/2008 08:45:56,spid187,Unknown,013B50A3 Module(sqlservr+003B50A3)
06/06/2008 08:45:56,spid187,Unknown,012FB17F Module(sqlservr+002FB17F)
06/06/2008 08:45:56,spid187,Unknown,012FBE95 Module(sqlservr+002FBE95)
06/06/2008 08:45:56,spid187,Unknown,012FBDDB Module(sqlservr+002FBDDB)
06/06/2008 08:45:56,spid187,Unknown,011A06A5 Module(sqlservr+001A06A5)
06/06/2008 08:45:56,spid187,Unknown,01482AB3 Module(sqlservr+00482AB3)
06/06/2008 08:45:56,spid187,Unknown,01443470 Module(sqlservr+00443470)
06/06/2008 08:45:56,spid187,Unknown,015BFA3D Module(sqlservr+005BFA3D)
06/06/2008 08:45:56,spid187,Unknown,021A642D Module(sqlservr+011A642D)
06/06/2008 08:45:56,spid187,Unknown,021A6880 Module(sqlservr+011A6880)
06/06/2008 08:45:56,spid187,Unknown,021A29C4 Module(sqlservr+011A29C4)
06/06/2008 08:45:56,spid187,Unknown,77E4BEE7 Module(kernel32+0000BEE7)
06/06/2008 08:45:56,spid187,Unknown,* Short Stack Dump
06/06/2008 08:45:56,spid187,Unknown,* -------------------------------------------------------------------------------
06/06/2008 08:45:56,spid187,Unknown,* *******************************************************************************
06/06/2008 08:45:56,spid187,Unknown,* SegSs: 78130023: 00000000 00000000 00000000 00000000 00000000 00000000
06/06/2008 08:45:56,spid187,Unknown,* Esp: 664DD540: 0B74D5C0 000042AC 00000000 00000000 77E4BEE7 00000000
06/06/2008 08:45:56,spid187,Unknown,* EFlags: 00000246:
06/06/2008 08:45:56,spid187,Unknown,* SegCs: 664D001B: 00000000 00000100 FFFFFE00 FFFFFFFF FFFFFFFF FFFFFFFF
06/06/2008 08:45:56,spid187,Unknown,* Ebp: 664DD594: 664DD5D8 021A29C4 000042AC 00000000 00000000 00000000
06/06/2008 08:45:56,spid187,Unknown,* Eip: 77E4BEE7: 10C2C95E 01093D00 840FC000 00000095 F29DE950 9090FFFF
06/06/2008 08:45:56,spid187,Unknown,* Edx: FFFFFFFF:
06/06/2008 08:45:56,spid187,Unknown,* Ecx: 664DDBB4: 00000000 00010007 00000000 0090008E 65153AFC 664DD574
06/06/2008 08:45:56,spid187,Unknown,* Ebx: FFFFFFFF:
06/06/2008 08:45:56,spid187,Unknown,* Eax: 664DD544: 000042AC 00000000 00000000 77E4BEE7 00000000 7C82771B
06/06/2008 08:45:56,spid187,Unknown,* Esi: 00000000:
06/06/2008 08:45:56,spid187,Unknown,* Edi: 664DD660: 65153AF8 664DD684 01006176 664DD684 0100617E 027E5570
06/06/2008 08:45:56,spid187,Unknown,*
06/06/2008 08:45:56,spid187,Unknown,* dbghelp 66BE0000 66CF4FFF 00115000
06/06/2008 08:45:56,spid187,Unknown,* OLEDB32R 63D60000 63D70FFF 00011000
06/06/2008 08:45:56,spid187,Unknown,* MSDART 63C10000 63C29FFF 0001a000
06/06/2008 08:45:56,spid187,Unknown,* oledb32 64090000 64108FFF 00079000
06/06/2008 08:45:56,spid187,Unknown,* xplog70 64730000 64732FFF 00003000
06/06/2008 08:45:56,spid187,Unknown,* xplog70 64710000 6471BFFF 0000c000
06/06/2008 08:45:56,spid187,Unknown,* xpstar90 645E0000 64605FFF 00026000
06/06/2008 08:45:56,spid187,Unknown,* odbcint 645C0000 645D6FFF 00017000
06/06/2008 08:45:56,spid187,Unknown,* ATL80 7C630000 7C64AFFF 0001b000
06/06/2008 08:45:56,spid187,Unknown,* BatchParser90 643D0000 643EEFFF 0001f000
06/06/2008 08:45:56,spid187,Unknown,* ODBC32 64390000 643CCFFF 0003d000
06/06/2008 08:45:56,spid187,Unknown,* SQLSCM90 64370000 64378FFF 00009000
06/06/2008 08:45:56,spid187,Unknown,* xpstar90 64310000 64358FFF 00049000
06/06/2008 08:45:56,spid187,Unknown,* xpsqlbot 642F0000 642F5FFF 00006000
06/06/2008 08:45:56,spid187,Unknown,* msftepxy 637C0000 637D4FFF 00015000
06/06/2008 08:45:56,spid187,Unknown,* SQLNCLIR 007C0000 007F2FFF 00033000
06/06/2008 08:45:56,spid187,Unknown,* comdlg32 762B0000 762F8FFF 00049000
06/06/2008 08:45:56,spid187,Unknown,* COMCTL32 77530000 775C6FFF 00097000
06/06/2008 08:45:56,spid187,Unknown,* sqlncli 63410000 63633FFF 00224000
06/06/2008 08:45:56,spid187,Unknown,* CLBCatQ 777B0000 77832FFF 00083000
06/06/2008 08:45:56,spid187,Unknown,* xpsp2res 63140000 63404FFF 002c5000
06/06/2008 08:45:56,spid187,Unknown,* ntdsapi 766F0000 76703FFF 00014000
06/06/2008 08:45:56,spid187,Unknown,* SAMLIB 7E020000 7E02EFFF 0000f000
06/06/2008 08:45:56,spid187,Unknown,* NTMARTA 77E00000 77E20FFF 00021000
06/06/2008 08:45:56,spid187,Unknown,* wshtcpip 71AE0000 71AE7FFF 00008000
06/06/2008 08:45:56,spid187,Unknown,* hnetcfg 62FA0000 62FF9FFF 0005a000
06/06/2008 08:45:56,spid187,Unknown,* dssenh 68100000 68126FFF 00027000
06/06/2008 08:45:56,spid187,Unknown,* imagehlp 76C10000 76C37FFF 00028000
06/06/2008 08:45:56,spid187,Unknown,* WINTRUST 76BB0000 76BDAFFF 0002b000
06/06/2008 08:45:56,spid187,Unknown,* dbghelp 62BB0000 62CC4FFF 00115000
06/06/2008 08:45:56,spid187,Unknown,* msfte 62950000 62BA8FFF 00259000
06/06/2008 08:45:56,spid187,Unknown,* security 62280000 62283FFF 00004000
06/06/2008 08:45:56,spid187,Unknown,* rasadhlp 76F80000 76F84FFF 00005000
06/06/2008 08:45:56,spid187,Unknown,* WLDAP32 76F10000 76F3DFFF 0002e000
06/06/2008 08:45:56,spid187,Unknown,* winrnr 76F70000 76F76FFF 00007000
06/06/2008 08:45:56,spid187,Unknown,* DNSAPI 76ED0000 76EF9FFF 0002a000
06/06/2008 08:45:56,spid187,Unknown,* RESUTILS 61E30000 61E42FFF 00013000
06/06/2008 08:45:56,spid187,Unknown,* CLUSAPI 61E10000 61E21FFF 00012000
06/06/2008 08:45:56,spid187,Unknown,* WSOCK32 71BB0000 71BB8FFF 00009000
06/06/2008 08:45:56,spid187,Unknown,* VERSION 77B90000 77B97FFF 00008000
06/06/2008 08:45:56,spid187,Unknown,* MTXCLU 61DF0000 61E08FFF 00019000
06/06/2008 08:45:56,spid187,Unknown,* msvcp60 61D80000 61DE4FFF 00065000
06/06/2008 08:45:56,spid187,Unknown,* OLEAUT32 77D00000 77D8AFFF 0008b000
06/06/2008 08:45:56,spid187,Unknown,* MSDTCPRX 61D00000 61D78FFF 00079000
06/06/2008 08:45:56,spid187,Unknown,* XOLEHLP 61CF0000 61CF5FFF 00006000
06/06/2008 08:45:56,spid187,Unknown,* COMRES 77010000 770D5FFF 000c6000
06/06/2008 08:45:56,spid187,Unknown,* schannel 76750000 76776FFF 00027000
06/06/2008 08:45:56,spid187,Unknown,* cryptdll 766E0000 766EBFFF 0000c000
06/06/2008 08:45:56,spid187,Unknown,* kerberos 61C40000 61C97FFF 00058000
06/06/2008 08:45:56,spid187,Unknown,* iphlpapi 76CF0000 76D09FFF 0001a000
06/06/2008 08:45:56,spid187,Unknown,* msv1_0 76C90000 76CB6FFF 00027000
06/06/2008 08:45:56,spid187,Unknown,* ole32 77670000 777A8FFF 00139000
06/06/2008 08:45:56,spid187,Unknown,* MSCOREE 34200000 34245FFF 00046000
06/06/2008 08:45:56,spid187,Unknown,* AUTHZ 76C40000 76C53FFF 00014000
06/06/2008 08:45:56,spid187,Unknown,* rsaenh 68000000 68034FFF 00035000
06/06/2008 08:45:56,spid187,Unknown,* SQLOS 344D0000 344D4FFF 00005000
06/06/2008 08:45:56,spid187,Unknown,* sqlevn70 4F610000 4F7B8FFF 001a9000
06/06/2008 08:45:56,spid187,Unknown,* instapi 48060000 48069FFF 0000a000
06/06/2008 08:45:56,spid187,Unknown,* psapi 76B70000 76B7AFFF 0000b000
06/06/2008 08:45:56,spid187,Unknown,* comctl32 77420000 77522FFF 00103000
06/06/2008 08:45:56,spid187,Unknown,* SHLWAPI 77DA0000 77DF1FFF 00052000
06/06/2008 08:45:56,spid187,Unknown,* SHELL32 7C8D0000 7D0CEFFF 007ff000
06/06/2008 08:45:56,spid187,Unknown,* NETAPI32 71C40000 71C96FFF 00057000
06/06/2008 08:45:56,spid187,Unknown,* opends60 333E0000 333E6FFF 00007000
06/06/2008 08:45:56,spid187,Unknown,* USERENV 76920000 769E1FFF 000c2000
06/06/2008 08:45:56,spid187,Unknown,* WS2HELP 71BF0000 71BF7FFF 00008000
06/06/2008 08:45:56,spid187,Unknown,* WS2_32 71C00000 71C16FFF 00017000
06/06/2008 08:45:56,spid187,Unknown,* MSWSOCK 71B20000 71B60FFF 00041000
06/06/2008 08:45:56,spid187,Unknown,* MSASN1 76190000 761A1FFF 00012000
06/06/2008 08:45:56,spid187,Unknown,* CRYPT32 761B0000 76242FFF 00093000
06/06/2008 08:45:56,spid187,Unknown,* GDI32 77C00000 77C47FFF 00048000
06/06/2008 08:45:56,spid187,Unknown,* USER32 77380000 77410FFF 00091000
06/06/2008 08:45:56,spid187,Unknown,* Secur32 76F50000 76F62FFF 00013000
06/06/2008 08:45:56,spid187,Unknown,* RPCRT4 77C50000 77CEEFFF 0009f000
06/06/2008 08:45:56,spid187,Unknown,* ADVAPI32 77F50000 77FEAFFF 0009b000
06/06/2008 08:45:56,spid187,Unknown,* MSVCP80 7C420000 7C4A6FFF 00087000
06/06/2008 08:45:56,spid187,Unknown,* msvcrt 77BA0000 77BF9FFF 0005a000
06/06/2008 08:45:56,spid187,Unknown,* MSVCR80 78130000 781CAFFF 0009b000
06/06/2008 08:45:56,spid187,Unknown,* kernel32 77E40000 77F41FFF 00102000
06/06/2008 08:45:56,spid187,Unknown,* ntdll 7C800000 7C8BFFFF 000c0000
06/06/2008 08:45:56,spid187,Unknown,* sqlservr 01000000 02C09FFF 01c0a000
06/06/2008 08:45:56,spid187,Unknown,* MODULE BASE END SIZE
06/06/2008 08:45:56,spid187,Unknown,*
06/06/2008 08:45:56,spid187,Unknown,*
06/06/2008 08:45:56,spid187,Unknown,* 04 04 00 00 00 00
06/06/2008 08:45:56,spid187,Unknown,* h r e s h o l d & 68 00 72 00 65 00 73 00 68 00 6f 00 6c 00 64 00 00 26
06/06/2008 08:45:56,spid187,Unknown,* T h r o t t l e T 54 00 68 00 72 00 6f 00 74 00 74 00 6c 00 65 00 54 00
06/06/2008 08:45:56,spid187,Unknown,* i z e & d @ 00 69 00 7a 00 65 00 00 26 04 04 64 00 00 00 12 40 00
06/06/2008 08:45:56,spid187,Unknown,* M a x F e t c h S 00 4d 00 61 00 78 00 46 00 65 00 74 00 63 00 68 00 53
06/06/2008 08:45:56,spid187,Unknown,* I d ç ÿÿ @ 00 49 00 64 00 00 e7 02 00 09 04 10 00 00 ff ff 0d 40
06/06/2008 08:45:56,spid187,Unknown,* É µ @ B a t c h 00 a0 c9 0a b5 0f 08 40 00 42 00 61 00 74 00 63 00 68
06/06/2008 08:45:56,spid187,Unknown,* p e $ ßê½eÂ� ¼à 70 00 65 00 00 24 10 10 17 df ea bd 65 c2 d0 11 bc ed
06/06/2008 08:45:56,spid187,Unknown,* o r k I t e m T y 6f 00 72 00 6b 00 49 00 74 00 65 00 6d 00 54 00 79 00
06/06/2008 08:45:56,spid187,Unknown,* d ç ÿÿ @ W 64 00 00 e7 02 00 09 04 10 00 00 ff ff 0d 40 00 57 00
06/06/2008 08:45:56,spid187,Unknown,* å ô« @ S i t e I e5 80 f4 ab 15 07 40 00 53 00 69 00 74 00 65 00 49 00
06/06/2008 08:45:56,spid187,Unknown,* d $ & Ǿ´Ó>Kµ�X 00 64 00 00 24 10 10 26 06 c7 be b4 d3 3e 4b b5 cd 58
06/06/2008 08:45:56,spid187,Unknown,* o c e s s i n g I 00 6f 00 63 00 65 00 73 00 73 00 69 00 6e 00 67 00 49
06/06/2008 08:45:56,spid187,Unknown,* I t e m s @ P r 49 00 74 00 65 00 6d 00 73 00 00 00 0d 40 00 50 00 72
06/06/2008 08:45:56,spid187,Unknown,* n a b l e W o r k 6e 00 61 00 62 00 6c 00 65 00 57 00 6f 00 72 00 6b 00
06/06/2008 08:45:56,spid187,Unknown,* o c _ G e t R u n 6f 00 63 00 5f 00 47 00 65 00 74 00 52 00 75 00 6e 00
06/06/2008 08:45:56,spid187,Unknown,* d b o . p r 01 00 00 00 1d 00 64 00 62 00 6f 00 2e 00 70 00 72 00
06/06/2008 08:45:56,spid187,Unknown,* 16 00 00 00 12 00 00 00 02 00 00 00 00 00 00 00 00 00
06/06/2008 08:45:56,spid187,Unknown,* Input Buffer 255 bytes -
06/06/2008 08:45:56,spid187,Unknown,*
06/06/2008 08:45:56,spid187,Unknown,* ex_raise2: Exception raised<c/> major=2<c/> minor=11<c/> state=51<c/> severity=23
06/06/2008 08:45:56,spid187,Unknown,*
06/06/2008 08:45:56,spid187,Unknown,* 06/06/08 08:45:56 spid 187
06/06/2008 08:45:56,spid187,Unknown,* BEGIN STACK DUMP:
06/06/2008 08:45:56,spid187,Unknown,*
06/06/2008 08:45:56,spid187,Unknown,* *******************************************************************************
06/06/2008 08:45:56,spid187,Unknown,***Stack Dump being sent to C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGSQLDump9210.txt
06/06/2008 08:45:56,spid187,Unknown,*
06/06/2008 08:45:56,spid187,Unknown,* User initiated stack dump. This is not a server exception dump.
06/06/2008 08:45:56,spid187,Unknown,*
06/06/2008 08:45:56,spid187,Unknown,**Dump thread - spid = 187<c/> PSS = 0x0B74D5C0<c/> EC = 0x0B74D5C8
06/06/2008 08:45:56,spid187,Unknown,Using 'dbghelp.dll' version '4.0.5'
06/06/2008 08:45:56,spid187,Unknown,ex_raise2: Exception raised<c/> major=2<c/> minor=11<c/> state=51<c/> severity=23<c/> attempting to create symptom dump
Any help would be greatly appreciated
View 3 Replies
View Related