Unanswered: MS SQL Server - sleeping processes that reawaken
We are runnoing SQL server enterprise manager on a Win2K box. In the Process Info view, there are several processes that are in a "sleeping" state whose hostname references a machine that is no longer on our network.
When I try to kill the process, it does go away (verified by both the "Current SQL Server Log" and in the Evenet Manager), but a few minutes later, the process reappears with the same PID and Hostname.
The records are existing in your master..sysprocesses. Killing those SPID's would suffice. In case it is coming back, maybe somebody has changed his machine name to that machine name as that machine no longer exists. And then he is accessing your SQL Server.