Thanks for your responses. We do run Veritas backup component. I will check the schedule and view history to find out what time it hits the server in question for...

Thanks for your response. Sp_cycle_errorlog has helped me to resolve my issue.

Thanks

SQL mail and sql agent are running under domain account other than sa. Outlook 2000 is running properly. This happens once in a while. In middle of process running, something...

I did try it, but did not work.

Thanks

We have tried to stop the SQL services but it did not work. When you click on Stop services, it would indicate that "stopping" the services and that's it. It...

Process has multiple steps. Calls for dtsrun, xp_sendmail, xp_cmdshell to copy file to archive directory, ftp to copy to other destination and run regular data manipulation within a stored proc....

i had to restart the SQL Server. I was not able to kill the process.

When i ran killl [SPID] WITH STATUSONLY

got return value 0.

After rebooting the server,...

i had to restart the SQL Server. I was not able to kill the process.

When i ran killl [SPID] WITH STATUSONLY

got return value 0.

After rebooting the server,...