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.