Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
'The TSQL subsystem failed to load'
Guys, Below is a more detailed description of what we are doing. The job has 12 steps and runs at midnight, the step that fails is step 1 which is below. exec usp_KillUsers 'Postilion' However during investigating the problem I added the following step as step 1 xp_cmdshell 'net stop...- isond
- Post #6
- Forum: Microsoft SQL Server: Setup and Administration
-
'The TSQL subsystem failed to load'
J. Kusch, No but I added extra steps to the same job and the issue occurred on these steps as well. The step that first caused the issue was to kill all users from a database. The extra steps I put in were to stop and start a service that we thought might be causing a problem. Since adding...- isond
- Post #3
- Forum: Microsoft SQL Server: Setup and Administration
-
'The TSQL subsystem failed to load'
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...- isond
- Thread
- Replies: 5
- Forum: Microsoft SQL Server: Setup and Administration
