The TSQL subsystem failed to load

• Darren Ison

  SSC Enthusiast

  Points: 140

  More actions

  April 19, 2004 at 5:27 am

  #108009

  Hi,

  I get the error 'The TSQL subsystem failed to load' when running a scheduled SQL Task, the actual step that fails seems to vary. Once this error occurs the job becomes suspended and I have to restart SQL Agent in order to be able to attempt to re-run the job. The job then re-runs fine with no errors.

  I have looked on various web sites including Microsofts and can't find any reference to this problem.

  Any help would be greatly appriciated.

  Thanks,

  Darren Ison.

• Kenneth Wilhelmsson

  SSC-Dedicated

  Points: 30043

  More actions

  April 19, 2004 at 5:37 am

  #503295

  Could it be this?

  http://support.microsoft.com/default.aspx?scid=kb;en-us;315005&Product=sql

  /Kenneth

• Darren Ison

  SSC Enthusiast

  Points: 140

  More actions

  April 19, 2004 at 5:43 am

  #503296

  Kenneth,

  No we have version 3.81 so this should not be the issue.

  Thanks,

  Darren.