'TSQL subsystem failed to load'

[bunmiA]

I keep getting the error 'TSQL subsystem failed to load, the job has been suspended'.

This error happens on a SQL server job on a daily schedule. It only seems to occur occassionaly. This problem has occured twice in the last week. It doesnt seem to happen on a particular job step, but when it does happen, I dont have a choice but to restart SQL as it puts the job in a suspended state.

SQL Server version: 2000 and the ODBC version:3.81.

Does anyone have any ideas, or has anyone seen this before?

 

[nigelrivett]

Which service pack on sql server?
You should have at least sp3

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[bunmiA]

MS SQL server 2000 sp6