1.SQLserver 2008 R2
2.64位系统
3.开始有一个长期的Access链接服务器导数据,运行正常
4.最近建了一个txt文本的链接服务器,运行一定时间后报错,造成与Access相关的job停滞,其他job正常EXEC master.dbo.sp_addlinkedserver --创建链接服务器
  @provider = 'Microsoft.Ace.OLEDB.12.0',  
  @srvproduct = 'SCLoad.mdb-Access',
  @server = 'Access',
  @datasrc = @path --存储过程中的参数  
=========================================================================
  EXEC master.dbo.sp_addlinkedserver --创建链接服务器
  @provider = 'Microsoft.Ace.OLEDB.12.0',  
  @srvproduct = 'DIF-txt’,
  @server = 'txtsrv',
  @datasrc = ‘D:\Data’, --多个txt文本存放处
  @provstr='Text'
将txt相关job在我本机(32位,'Microsoft.Jet.OLEDB.4.0')上单独运行则没问题2012-02-21 00:30:02.22 spid64 Using 'dbghelp.dll' version '4.0.5'
2012-02-21 00:30:02.26 spid64 ***Stack Dump being sent to D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\LOG\SQLDump0030.txt
2012-02-21 00:30:02.26 spid64 SqlDumpExceptionHandler: Process 64 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
2012-02-21 00:30:02.26 spid64 * *******************************************************************************
2012-02-21 00:30:02.26 spid64 *
2012-02-21 00:30:02.26 spid64 * BEGIN STACK DUMP:
2012-02-21 00:30:02.26 spid64 * 02/21/12 00:30:02 spid 64
2012-02-21 00:30:02.26 spid64 *
2012-02-21 00:30:02.26 spid64 *
2012-02-21 00:30:02.26 spid64 * Exception Address = 000007FEE3460D4A Module(mso+0000000000050D4A)
2012-02-21 00:30:02.26 spid64 * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
2012-02-21 00:30:02.26 spid64 * Access Violation occurred reading address 000007FEECDE5728
2012-02-21 00:30:02.26 spid64 * Input Buffer 72 bytes -
2012-02-21 00:30:02.26 spid64 * exec dbo.Job_Diffuse_Data
2012-02-21 00:30:02.26 spid64 *   
2012-02-21 00:30:02.26 spid64 *
2012-02-21 00:30:02.26 spid64 * MODULE BASE END SIZE
2012-02-21 00:30:02.26 spid64 * sqlservr 0000000000A30000 00000000045DDFFF 03bae000
2012-02-21 00:30:02.26 spid64 * ntdll 0000000077140000 00000000772E8FFF 001a9000
2012-02-21 00:30:02.26 spid64 * kernel32 0000000077020000 000000007713EFFF 0011f000
2012-02-21 00:30:02.26 spid64 * KERNELBASE 000007FEFD1A0000 000007FEFD20AFFF 0006b000
2012-02-21 00:30:02.26 spid64 * ADVAPI32 000007FEFECA0000 000007FEFED7AFFF 000db000
2012-02-21 00:30:02.26 spid64 * msvcrt 000007FEFD840000 000007FEFD8DEFFF 0009f000
2012-02-21 00:30:02.26 spid64 * sechost 000007FEFEB90000 000007FEFEBAEFFF 0001f000
2012-02-21 00:30:02.26 spid64 * RPCRT4 000007FEFE860000 000007FEFE98CFFF 0012d000
2012-02-21 00:30:02.26 spid64 * MSVCR80 0000000074D30000 0000000074DF8FFF 000c9000
2012-02-21 00:30:02.26 spid64 * MSVCP80 0000000074C20000 0000000074D28FFF 00109000
2012-02-21 00:30:02.26 spid64 * sqlos 0000000074C10000 0000000074C16FFF 00007000
2012-02-21 00:30:02.26 spid64 * Secur32 000007FEFC9A0000 000007FEFC9AAFFF 0000b000
2012-02-21 00:30:02.26 spid64 * SSPICLI 000007FEFCC20000 000007FEFCC44FFF 00025000
2012-02-21 00:30:02.26 spid64 * pdh 000007FEF6510000 000007FEF655DFFF 0004e000
2012-02-21 00:30:02.26 spid64 * SHLWAPI 000007FEFF3D0000 000007FEFF440FFF 00071000
2012-02-21 00:30:02.26 spid64 * GDI32 000007FEFE9C0000 000007FEFEA26FFF 00067000
2012-02-21 00:30:02.26 spid64 * USER32 0000000076F20000 0000000077019FFF 000fa000
2012-02-21 00:30:02.26 spid64 * LPK 000007FEFE850000 000007FEFE85DFFF 0000e000
2012-02-21 00:30:02.26 spid64 * USP10 000007FEFEF70000 000007FEFF038FFF 000c9000
2012-02-21 00:30:02.26 spid64 * USERENV 000007FEFCF70000 000007FEFCF8DFFF 0001e000
2012-02-21 00:30:02.26 spid64 * profapi 000007FEFCF60000 000007FEFCF6EFFF 0000f000
2012-02-21 00:30:02.26 spid64 * WINMM 000007FEF6590000 000007FEF65CAFFF 0003b000
2012-02-21 00:30:02.26 spid64 * IPHLPAPI 000007FEFCDF0000 000007FEFCE16FFF 00027000
2012-02-21 00:30:02.26 spid64 * NSI 000007FEFEC90000 000007FEFEC97FFF 000080002012-02-21 00:30:02.27 spid64 * Short Stack Dump
2012-02-21 00:30:02.36 spid64 000007FEE3460D4A Module(mso+0000000000050D4A)
2012-02-21 00:30:02.36 spid64 000007FEE3430148 Module(mso+0000000000020148)
2012-02-21 00:30:02.36 spid64 000007FEE353D281 Module(mso+000000000012D281)
2012-02-21 00:30:02.36 spid64 000007FEE3435C15 Module(mso+0000000000025C15)
2012-02-21 00:30:02.36 spid64 000007FEED53C6F5 Module(ACETXT+000000000003C6F5)
2012-02-21 00:30:02.36 spid64 000007FEED5268B5 Module(ACETXT+00000000000268B5)
2012-02-21 00:30:02.36 spid64 000007FEED52685B Module(ACETXT+000000000002685B)
2012-02-21 00:30:02.36 spid64 000007FEED517E87 Module(ACETXT+0000000000017E87)
2012-02-21 00:30:02.37 spid64 000007FEEC24D350 Module(ACECORE+00000000000DD350)
2012-02-21 00:30:02.37 spid64 000007FEEC189EB5 Module(ACECORE+0000000000019EB5)
2012-02-21 00:30:02.37 spid64 000007FEEC18B465 Module(ACECORE+000000000001B465)
2012-02-21 00:30:02.37 spid64 000007FEED1D3ED1 Module(ACEOLEDB+0000000000003ED1)
2012-02-21 00:30:02.37 spid64 000007FEED1D3E95 Module(ACEOLEDB+0000000000003E95)
2012-02-21 00:30:02.37 spid64 000007FEED1D3E1E Module(ACEOLEDB+0000000000003E1E)
2012-02-21 00:30:02.37 spid64 000007FEED1D3AB3 Module(ACEOLEDB+0000000000003AB3)
2012-02-21 00:30:02.37 spid64 000007FEED1D3913 Module(ACEOLEDB+0000000000003913)
2012-02-21 00:30:02.37 spid64 000007FEED1D380D Module(ACEOLEDB+000000000000380D)
2012-02-21 00:30:02.38 spid64 000007FEED1D3698 Module(ACEOLEDB+0000000000003698)
2012-02-21 00:30:02.38 spid64 000007FEEC498C1E Module(oledb32+0000000000008C1E)
2012-02-21 00:30:02.38 spid64 000007FEEC498B56 Module(oledb32+0000000000008B56)
2012-02-21 00:30:02.38 spid64 000007FEEC4C7B8F Module(oledb32+0000000000037B8F)
2012-02-21 00:30:02.38 spid64 0000000001563FF1 Module(sqlservr+0000000000B33FF1)
2012-02-21 00:30:02.39 spid64 0000000001522867 Module(sqlservr+0000000000AF2867)
2012-02-21 00:30:02.39 spid64 00000000014FAB82 Module(sqlservr+0000000000ACAB82)
2012-02-21 00:30:02.39 spid64 000000000147BFDF Module(sqlservr+0000000000A4BFDF)
2012-02-21 00:30:02.39 spid64 000000000157F07D Module(sqlservr+0000000000B4F07D)
2012-02-21 00:30:02.39 spid64 000000000157D2EF Module(sqlservr+0000000000B4D2EF)
2012-02-21 00:30:02.39 spid64 000000000159C5C1 Module(sqlservr+0000000000B6C5C1)
2012-02-21 00:30:02.39 spid64 000000000159C3DD Module(sqlservr+0000000000B6C3DD)
2012-02-21 00:30:02.39 spid64 0000000001E94813 Module(sqlservr+0000000001464813)
2012-02-21 00:30:02.39 spid64 0000000000ACD555 Module(sqlservr+000000000009D555)
2012-02-21 00:30:02.39 spid64 0000000000ACBA8F Module(sqlservr+000000000009BA8F)
2012-02-21 00:30:02.40 spid64 0000000001F50CCD Module(sqlservr+0000000001520CCD)
2012-02-21 00:30:02.40 spid64 0000000001F512EF Module(sqlservr+00000000015212EF)
2012-02-21 00:30:02.40 spid64 0000000000A89D59 Module(sqlservr+0000000000059D59)
2012-02-21 00:30:02.40 spid64 0000000000A8A9B8 Module(sqlservr+000000000005A9B8)
2012-02-21 00:30:02.40 spid64 0000000000A8B30C Module(sqlservr+000000000005B30C)
2012-02-21 00:30:02.40 spid64 0000000001F1F68E Module(sqlservr+00000000014EF68E)
2012-02-21 00:30:02.40 spid64 0000000001F1B4F1 Module(sqlservr+00000000014EB4F1)
2012-02-21 00:30:02.40 spid64 0000000000A89D59 Module(sqlservr+0000000000059D59)
2012-02-21 00:30:02.40 spid64 0000000000A8A9B8 Module(sqlservr+000000000005A9B8)
2012-02-21 00:30:02.40 spid64 0000000000A8B30C Module(sqlservr+000000000005B30C)
2012-02-21 00:30:02.40 spid64 0000000001F1D7CC Module(sqlservr+00000000014ED7CC)
2012-02-21 00:30:02.40 spid64 0000000001F1D12A Module(sqlservr+00000000014ED12A)
2012-02-21 00:30:02.41 spid64 0000000001F1B11D Module(sqlservr+00000000014EB11D)
2012-02-21 00:30:02.41 spid64 0000000000A89D59 Module(sqlservr+0000000000059D59)
2012-02-21 00:30:02.41 spid64 0000000000A8A9B8 Module(sqlservr+000000000005A9B8)
2012-02-21 00:30:02.41 spid64 0000000000A8B30C Module(sqlservr+000000000005B30C)
2012-02-21 00:30:02.41 spid64 0000000000A8C1A6 Module(sqlservr+000000000005C1A6)
2012-02-21 00:30:02.41 spid64 0000000000AD5342 Module(sqlservr+00000000000A5342)
2012-02-21 00:30:02.41 spid64 0000000000A3BBD8 Module(sqlservr+000000000000BBD8)
2012-02-21 00:30:02.41 spid64 0000000000A3B8BA Module(sqlservr+000000000000B8BA)
2012-02-21 00:30:02.41 spid64 0000000000A3B6FF Module(sqlservr+000000000000B6FF)
2012-02-21 00:30:02.41 spid64 0000000000F58FB6 Module(sqlservr+0000000000528FB6)
2012-02-21 00:30:02.42 spid64 0000000000F59175 Module(sqlservr+0000000000529175)
2012-02-21 00:30:02.42 spid64 0000000000F59839 Module(sqlservr+0000000000529839)
2012-02-21 00:30:02.43 spid64 0000000000F59502 Module(sqlservr+0000000000529502)
2012-02-21 00:30:02.43 spid64 0000000074D337D7 Module(MSVCR80+00000000000037D7)
2012-02-21 00:30:02.43 spid64 0000000074D33894 Module(MSVCR80+0000000000003894)
2012-02-21 00:30:02.45 spid64 000000007703652D Module(kernel32+000000000001652D)
2012-02-21 00:30:02.45 spid64 000000007716C521 Module(ntdll+000000000002C521)
2012-02-21 00:30:02.48 spid64 Stack Signature for the dump is 0x00000001287240F0请各路大神帮忙!!