Feb 26, 2008
Hi all. I am running on SQL 2005 Standard eddition SP2, Also did install " KB Article Number(s): 944929, 946608, 948490, 949118". Running on 2003 server.
Error:
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
I have 2 servers. One of them is free text seach with files stored in DB. On main server there is a link back to this file DB server.
I am trying to run this script and then error from above... link_kance_doc is link to table on other server. Strange thing is when I run this same script on server 3 with same link to file DB server it works. It also works when runed on file DB server.
Also, if I dont use WHERE CONTRAINS SQL does return Dataset..
SELECT link_kance_doc.ID, link_kance_doc.DocName, link_kance_doc.DocExtension, link_kance_doc.KancelID, link_kance_doc.Comments,
link_kance_doc.CreateByUser, link_kance_doc.CreateTS, link_kance_doc.ActiveYN
FROM link_kance_doc
where Contains(*,'"murte"')
Any ideas..
Server LOG
02/26/2008 16:54:05,Server,Unknown,A user request from the session with SPID 57 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory.
02/26/2008 16:54:05,Server,Unknown,Error: 17310<c/> Severity: 20<c/> State: 1.
02/26/2008 16:54:05,spid57,Unknown,External dump process return code 0x20000001.<nl/>External dump process returned no errors.
02/26/2008 16:54:04,spid57,Unknown,Stack Signature for the dump is 0x28BDEE59
02/26/2008 16:54:04,spid57,Unknown,78132A47 Module(MSVCR80+00002A47)
02/26/2008 16:54:04,spid57,Unknown,781329BB Module(MSVCR80+000029BB)
02/26/2008 16:54:04,spid57,Unknown,010B9201 Module(sqlservr+000B9201)
02/26/2008 16:54:04,spid57,Unknown,010B9064 Module(sqlservr+000B9064)
02/26/2008 16:54:04,spid57,Unknown,010B939C Module(sqlservr+000B939C)
02/26/2008 16:54:04,spid57,Unknown,010B94A5 Module(sqlservr+000B94A5)
02/26/2008 16:54:04,spid57,Unknown,010075DC Module(sqlservr+000075DC)
02/26/2008 16:54:04,spid57,Unknown,010078CC Module(sqlservr+000078CC)
02/26/2008 16:54:04,spid57,Unknown,010077A6 Module(sqlservr+000077A6)
02/26/2008 16:54:04,spid57,Unknown,0102F1F4 Module(sqlservr+0002F1F4)
02/26/2008 16:54:04,spid57,Unknown,01032A36 Module(sqlservr+00032A36)
02/26/2008 16:54:04,spid57,Unknown,01028600 Module(sqlservr+00028600)
02/26/2008 16:54:04,spid57,Unknown,0134752A Module(sqlservr+0034752A)
02/26/2008 16:54:04,spid57,Unknown,01430633 Module(sqlservr+00430633)
02/26/2008 16:54:04,spid57,Unknown,01346B6B Module(sqlservr+00346B6B)
02/26/2008 16:54:04,spid57,Unknown,013A929A Module(sqlservr+003A929A)
02/26/2008 16:54:04,spid57,Unknown,01368BB2 Module(sqlservr+00368BB2)
02/26/2008 16:54:04,spid57,Unknown,013A9BDC Module(sqlservr+003A9BDC)
02/26/2008 16:54:04,spid57,Unknown,013A9A04 Module(sqlservr+003A9A04)
02/26/2008 16:54:04,spid57,Unknown,013AFC6E Module(sqlservr+003AFC6E)
02/26/2008 16:54:04,spid57,Unknown,013A9A04 Module(sqlservr+003A9A04)
02/26/2008 16:54:04,spid57,Unknown,013AF8D0 Module(sqlservr+003AF8D0)
02/26/2008 16:54:04,spid57,Unknown,013A9A04 Module(sqlservr+003A9A04)
02/26/2008 16:54:04,spid57,Unknown,013B0CC7 Module(sqlservr+003B0CC7)
02/26/2008 16:54:04,spid57,Unknown,013A9A04 Module(sqlservr+003A9A04)
02/26/2008 16:54:04,spid57,Unknown,013A9DC5 Module(sqlservr+003A9DC5)
02/26/2008 16:54:04,spid57,Unknown,013A9F20 Module(sqlservr+003A9F20)
02/26/2008 16:54:04,spid57,Unknown,01B2E1B9 Module(sqlservr+00B2E1B9)
02/26/2008 16:54:04,spid57,Unknown,013A9A04 Module(sqlservr+003A9A04)
02/26/2008 16:54:04,spid57,Unknown,01B24372 Module(sqlservr+00B24372)
02/26/2008 16:54:04,spid57,Unknown,0136A2D8 Module(sqlservr+0036A2D8)
02/26/2008 16:54:04,spid57,Unknown,0149C867 Module(sqlservr+0049C867)
02/26/2008 16:54:04,spid57,Unknown,0170D0CD Module(sqlservr+0070D0CD)
02/26/2008 16:54:04,spid57,Unknown,0170F7E3 Module(sqlservr+0070F7E3)
02/26/2008 16:54:04,spid57,Unknown,0170FB90 Module(sqlservr+0070FB90)
02/26/2008 16:54:04,spid57,Unknown,01702514 Module(sqlservr+00702514)
02/26/2008 16:54:04,spid57,Unknown,010A0F91 Module(sqlservr+000A0F91)
02/26/2008 16:54:04,spid57,Unknown,* Short Stack Dump
02/26/2008 16:54:04,spid57,Unknown,* -------------------------------------------------------------------------------
02/26/2008 16:54:04,spid57,Unknown,* *******************************************************************************
02/26/2008 16:54:04,spid57,Unknown,* SegSs: 00000023:
02/26/2008 16:54:04,spid57,Unknown,* Esp: 6373E24C: 00000004 00000000 6373E544 01702514 00000004 01019094
02/26/2008 16:54:04,spid57,Unknown,* EFlags: 00010206: 0055004E 0042004D 00520045 004F005F 005F0046 00520050
02/26/2008 16:54:04,spid57,Unknown,* SegCs: 0000001B:
02/26/2008 16:54:04,spid57,Unknown,* Ebp: 6373E254: 6373E544 01702514 00000004 01019094 637311EB 042DAD88
02/26/2008 16:54:04,spid57,Unknown,* Eip: 010A0F91: 103B118B B60FCD74 38B60F11 840FD72B 003D5E1C 01B8D285
02/26/2008 16:54:04,spid57,Unknown,* Edx: 042DAD48: 042DAAB8 042DA278 042DAA18 042DAD70 042DAF58 00000001
02/26/2008 16:54:04,spid57,Unknown,* Ecx: 00000004:
02/26/2008 16:54:04,spid57,Unknown,* Ebx: 05E929F8: 01622A98 00000001 00000000 00000000 00000000 00000000
02/26/2008 16:54:04,spid57,Unknown,* Eax: 01019094: 00000000 00000000 00000000 00000000 90909090 55FF8B90
02/26/2008 16:54:04,spid57,Unknown,* Esi: 00000010:
02/26/2008 16:54:04,spid57,Unknown,* Edi: 00000004:
02/26/2008 16:54:04,spid57,Unknown,*
02/26/2008 16:54:04,spid57,Unknown,* dbghelp 64600000 64714FFF 00115000
02/26/2008 16:54:04,spid57,Unknown,* MSDATL3 64450000 64464FFF 00015000
02/26/2008 16:54:04,spid57,Unknown,* sqloledb 643C0000 64440FFF 00081000
02/26/2008 16:54:04,spid57,Unknown,* xpstar90 64390000 643B5FFF 00026000
02/26/2008 16:54:04,spid57,Unknown,* msadcer 64380000 64384FFF 00005000
02/26/2008 16:54:04,spid57,Unknown,* msadce 64320000 64377FFF 00058000
02/26/2008 16:54:04,spid57,Unknown,* OLEDB32R 64300000 64310FFF 00011000
02/26/2008 16:54:04,spid57,Unknown,* MSDART 64060000 64079FFF 0001a000
02/26/2008 16:54:04,spid57,Unknown,* oledb32 63FE0000 64058FFF 00079000
02/26/2008 16:54:04,spid57,Unknown,* odbcint 63FC0000 63FD6FFF 00017000
02/26/2008 16:54:04,spid57,Unknown,* ATL80 7C630000 7C64AFFF 0001b000
02/26/2008 16:54:04,spid57,Unknown,* BatchParser90 63E50000 63E6EFFF 0001f000
02/26/2008 16:54:04,spid57,Unknown,* ODBC32 63E10000 63E4CFFF 0003d000
02/26/2008 16:54:04,spid57,Unknown,* SQLSCM90 63DF0000 63DF8FFF 00009000
02/26/2008 16:54:04,spid57,Unknown,* xpstar90 63D90000 63DD8FFF 00049000
02/26/2008 16:54:04,spid57,Unknown,* msftepxy 63600000 63614FFF 00015000
02/26/2008 16:54:04,spid57,Unknown,* SQLNCLIR 00830000 00862FFF 00033000
02/26/2008 16:54:04,spid57,Unknown,* comdlg32 762B0000 762F8FFF 00049000
02/26/2008 16:54:04,spid57,Unknown,* COMCTL32 77530000 775C6FFF 00097000
02/26/2008 16:54:04,spid57,Unknown,* sqlncli 631D0000 633F3FFF 00224000
02/26/2008 16:54:04,spid57,Unknown,* CLBCatQ 777B0000 77832FFF 00083000
02/26/2008 16:54:04,spid57,Unknown,* xpsp2res 62F00000 631C4FFF 002c5000
02/26/2008 16:54:04,spid57,Unknown,* ntdsapi 766F0000 76703FFF 00014000
02/26/2008 16:54:04,spid57,Unknown,* SAMLIB 7E020000 7E02EFFF 0000f000
02/26/2008 16:54:04,spid57,Unknown,* NTMARTA 77E00000 77E20FFF 00021000
02/26/2008 16:54:04,spid57,Unknown,* wshtcpip 71AE0000 71AE7FFF 00008000
02/26/2008 16:54:04,spid57,Unknown,* hnetcfg 62E60000 62EB9FFF 0005a000
02/26/2008 16:54:04,spid57,Unknown,* dssenh 68100000 68126FFF 00027000
02/26/2008 16:54:04,spid57,Unknown,* imagehlp 76C10000 76C37FFF 00028000
02/26/2008 16:54:04,spid57,Unknown,* WINTRUST 76BB0000 76BDAFFF 0002b000
02/26/2008 16:54:04,spid57,Unknown,* dbghelp 62B00000 62C14FFF 00115000
02/26/2008 16:54:04,spid57,Unknown,* msfte 628A0000 62AF8FFF 00259000
02/26/2008 16:54:04,spid57,Unknown,* security 62210000 62213FFF 00004000
02/26/2008 16:54:04,spid57,Unknown,* rasadhlp 76F80000 76F84FFF 00005000
02/26/2008 16:54:04,spid57,Unknown,* WLDAP32 76F10000 76F3DFFF 0002e000
02/26/2008 16:54:04,spid57,Unknown,* winrnr 76F70000 76F76FFF 00007000
02/26/2008 16:54:04,spid57,Unknown,* DNSAPI 76ED0000 76EF9FFF 0002a000
02/26/2008 16:54:04,spid57,Unknown,* RESUTILS 61DC0000 61DD2FFF 00013000
02/26/2008 16:54:04,spid57,Unknown,* CLUSAPI 61DA0000 61DB1FFF 00012000
02/26/2008 16:54:04,spid57,Unknown,* WSOCK32 71BB0000 71BB8FFF 00009000
02/26/2008 16:54:04,spid57,Unknown,* VERSION 77B90000 77B97FFF 00008000
02/26/2008 16:54:04,spid57,Unknown,* MTXCLU 61D80000 61D98FFF 00019000
02/26/2008 16:54:04,spid57,Unknown,* msvcp60 61D10000 61D74FFF 00065000
02/26/2008 16:54:04,spid57,Unknown,* OLEAUT32 77D00000 77D8AFFF 0008b000
02/26/2008 16:54:04,spid57,Unknown,* MSDTCPRX 61C90000 61D08FFF 00079000
02/26/2008 16:54:04,spid57,Unknown,* XOLEHLP 61C80000 61C85FFF 00006000
02/26/2008 16:54:04,spid57,Unknown,* COMRES 77010000 770D5FFF 000c6000
02/26/2008 16:54:04,spid57,Unknown,* schannel 76750000 76776FFF 00027000
02/26/2008 16:54:04,spid57,Unknown,* cryptdll 766E0000 766EBFFF 0000c000
02/26/2008 16:54:04,spid57,Unknown,* kerberos 61BD0000 61C27FFF 00058000
02/26/2008 16:54:04,spid57,Unknown,* iphlpapi 76CF0000 76D09FFF 0001a000
02/26/2008 16:54:04,spid57,Unknown,* msv1_0 76C90000 76CB6FFF 00027000
02/26/2008 16:54:04,spid57,Unknown,* ole32 77670000 777A8FFF 00139000
02/26/2008 16:54:04,spid57,Unknown,* MSCOREE 34190000 341D4FFF 00045000
02/26/2008 16:54:04,spid57,Unknown,* AUTHZ 76C40000 76C53FFF 00014000
02/26/2008 16:54:04,spid57,Unknown,* rsaenh 68000000 68034FFF 00035000
02/26/2008 16:54:04,spid57,Unknown,* SQLOS 344D0000 344D4FFF 00005000
02/26/2008 16:54:04,spid57,Unknown,* sqlevn70 4F610000 4F7B8FFF 001a9000
02/26/2008 16:54:04,spid57,Unknown,* instapi 48060000 48069FFF 0000a000
02/26/2008 16:54:04,spid57,Unknown,* psapi 76B70000 76B7AFFF 0000b000
02/26/2008 16:54:04,spid57,Unknown,* comctl32 77420000 77522FFF 00103000
02/26/2008 16:54:04,spid57,Unknown,* IMM32 76290000 762ACFFF 0001d000
02/26/2008 16:54:04,spid57,Unknown,* SHLWAPI 77DA0000 77DF1FFF 00052000
02/26/2008 16:54:04,spid57,Unknown,* SHELL32 7C8D0000 7D0CEFFF 007ff000
02/26/2008 16:54:04,spid57,Unknown,* NETAPI32 71C40000 71C96FFF 00057000
02/26/2008 16:54:04,spid57,Unknown,* opends60 333E0000 333E6FFF 00007000
02/26/2008 16:54:04,spid57,Unknown,* USERENV 76920000 769E1FFF 000c2000
02/26/2008 16:54:04,spid57,Unknown,* WS2HELP 71BF0000 71BF7FFF 00008000
02/26/2008 16:54:04,spid57,Unknown,* WS2_32 71C00000 71C16FFF 00017000
02/26/2008 16:54:04,spid57,Unknown,* MSWSOCK 71B20000 71B60FFF 00041000
02/26/2008 16:54:04,spid57,Unknown,* MSASN1 76190000 761A1FFF 00012000
02/26/2008 16:54:04,spid57,Unknown,* CRYPT32 761B0000 76242FFF 00093000
02/26/2008 16:54:04,spid57,Unknown,* GDI32 77C00000 77C47FFF 00048000
02/26/2008 16:54:04,spid57,Unknown,* USER32 77380000 77410FFF 00091000
02/26/2008 16:54:04,spid57,Unknown,* Secur32 76F50000 76F62FFF 00013000
02/26/2008 16:54:04,spid57,Unknown,* RPCRT4 77C50000 77CEEFFF 0009f000
02/26/2008 16:54:04,spid57,Unknown,* ADVAPI32 77F50000 77FEAFFF 0009b000
02/26/2008 16:54:04,spid57,Unknown,* MSVCP80 7C420000 7C4A6FFF 00087000
02/26/2008 16:54:04,spid57,Unknown,* msvcrt 77BA0000 77BF9FFF 0005a000
02/26/2008 16:54:04,spid57,Unknown,* MSVCR80 78130000 781CAFFF 0009b000
02/26/2008 16:54:04,spid57,Unknown,* kernel32 77E40000 77F41FFF 00102000
02/26/2008 16:54:04,spid57,Unknown,* ntdll 7C800000 7C8BFFFF 000c0000
02/26/2008 16:54:04,spid57,Unknown,* sqlservr 01000000 02C09FFF 01c0a000
02/26/2008 16:54:04,spid57,Unknown,* MODULE BASE END SIZE
02/26/2008 16:54:04,spid57,Unknown,*
02/26/2008 16:54:04,spid57,Unknown,*
02/26/2008 16:54:04,spid57,Unknown,* ins(*<c/>'"murte"')
02/26/2008 16:54:04,spid57,Unknown,* teTS<c/> link_kance_doc.ActiveYN FROM link_kance_doc where Conta
02/26/2008 16:54:04,spid57,Unknown,* link_kance_doc.CreateByUser<c/> link_kance_doc.Crea
02/26/2008 16:54:04,spid57,Unknown,* nce_doc.DocExtension<c/> link_kance_doc.KancelID<c/> link_kance_doc.Comments<c/>
02/26/2008 16:54:04,spid57,Unknown,* SELECT link_kance_doc.ID<c/> link_kance_doc.DocName<c/> link_ka
02/26/2008 16:54:04,spid57,Unknown,* Input Buffer 510 bytes -
02/26/2008 16:54:04,spid57,Unknown,* Access Violation occurred reading address 00000004
02/26/2008 16:54:04,spid57,Unknown,* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
02/26/2008 16:54:04,spid57,Unknown,* Exception Address = 010A0F91 Module(sqlservr+000A0F91)
02/26/2008 16:54:04,spid57,Unknown,*
02/26/2008 16:54:04,spid57,Unknown,*
02/26/2008 16:54:04,spid57,Unknown,* 02/26/08 16:54:04 spid 57
02/26/2008 16:54:04,spid57,Unknown,* BEGIN STACK DUMP:
02/26/2008 16:54:04,spid57,Unknown,*
02/26/2008 16:54:04,spid57,Unknown,* *******************************************************************************
02/26/2008 16:54:04,spid57,Unknown,SqlDumpExceptionHandler: Process 57 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
02/26/2008 16:54:04,spid57,Unknown,***Stack Dump being sent to C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGSQLDump0063.txt
02/26/2008 16:54:04,spid57,Unknown,Using 'dbghelp.dll' version '4.0.5'
02/26/2008 16:54:03,Server,Unknown,A user request from the session with SPID 57 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory.
02/26/2008 16:54:03,Server,Unknown,Error: 17310<c/> Severity: 20<c/> State: 1.
02/26/2008 16:54:03,spid57,Unknown,External dump process return code 0x20000001.<nl/>External dump process returned no errors.
02/26/2008 16:54:02,spid57,Unknown,Stack Signature for the dump is 0x28BDEE59
02/26/2008 16:54:02,spid57,Unknown,78132A47 Module(MSVCR80+00002A47)
02/26/2008 16:54:02,spid57,Unknown,781329BB Module(MSVCR80+000029BB)
02/26/2008 16:54:02,spid57,Unknown,010B9201 Module(sqlservr+000B9201)
02/26/2008 16:54:02,spid57,Unknown,010B9064 Module(sqlservr+000B9064)
02/26/2008 16:54:02,spid57,Unknown,010B939C Module(sqlservr+000B939C)
02/26/2008 16:54:02,spid57,Unknown,010B94A5 Module(sqlservr+000B94A5)
02/26/2008 16:54:02,spid57,Unknown,010075DC Module(sqlservr+000075DC)
02/26/2008 16:54:02,spid57,Unknown,010078CC Module(sqlservr+000078CC)
02/26/2008 16:54:02,spid57,Unknown,010077A6 Module(sqlservr+000077A6)
02/26/2008 16:54:02,spid57,Unknown,0102F1F4 Module(sqlservr+0002F1F4)
02/26/2008 16:54:02,spid57,Unknown,01032A36 Module(sqlservr+00032A36)
02/26/2008 16:54:02,spid57,Unknown,01028600 Module(sqlservr+00028600)
02/26/2008 16:54:02,spid57,Unknown,0134752A Module(sqlservr+0034752A)
02/26/2008 16:54:02,spid57,Unknown,01430633 Module(sqlservr+00430633)
02/26/2008 16:54:02,spid57,Unknown,01346B6B Module(sqlservr+00346B6B)
02/26/2008 16:54:02,spid57,Unknown,013A929A Module(sqlservr+003A929A)
02/26/2008 16:54:02,spid57,Unknown,01368BB2 Module(sqlservr+00368BB2)
02/26/2008 16:54:02,spid57,Unknown,013A9BDC Module(sqlservr+003A9BDC)
02/26/2008 16:54:02,spid57,Unknown,013A9A04 Module(sqlservr+003A9A04)
02/26/2008 16:54:02,spid57,Unknown,013AFC6E Module(sqlservr+003AFC6E)
02/26/2008 16:54:02,spid57,Unknown,013A9A04 Module(sqlservr+003A9A04)
02/26/2008 16:54:02,spid57,Unknown,013AF8D0 Module(sqlservr+003AF8D0)
02/26/2008 16:54:02,spid57,Unknown,013A9A04 Module(sqlservr+003A9A04)
02/26/2008 16:54:02,spid57,Unknown,013B0CC7 Module(sqlservr+003B0CC7)
02/26/2008 16:54:02,spid57,Unknown,013A9A04 Module(sqlservr+003A9A04)
02/26/2008 16:54:02,spid57,Unknown,013A9DC5 Module(sqlservr+003A9DC5)
02/26/2008 16:54:02,spid57,Unknown,013A9F20 Module(sqlservr+003A9F20)
02/26/2008 16:54:02,spid57,Unknown,01B2E1B9 Module(sqlservr+00B2E1B9)
02/26/2008 16:54:02,spid57,Unknown,013A9A04 Module(sqlservr+003A9A04)
02/26/2008 16:54:02,spid57,Unknown,01B24372 Module(sqlservr+00B24372)
02/26/2008 16:54:02,spid57,Unknown,0136A2D8 Module(sqlservr+0036A2D8)
02/26/2008 16:54:02,spid57,Unknown,0149C867 Module(sqlservr+0049C867)
02/26/2008 16:54:02,spid57,Unknown,0170D0CD Module(sqlservr+0070D0CD)
02/26/2008 16:54:02,spid57,Unknown,0170F7E3 Module(sqlservr+0070F7E3)
02/26/2008 16:54:02,spid57,Unknown,0170FB90 Module(sqlservr+0070FB90)
02/26/2008 16:54:02,spid57,Unknown,01702514 Module(sqlservr+00702514)
02/26/2008 16:54:02,spid57,Unknown,010A0F91 Module(sqlservr+000A0F91)
View 1 Replies
View Related