Running SQL2005, SP2. Checking connection status using Management | View Processes.
Users show connected long after they disconnect, even after they completely shut down their computer.
I use refresh to refresh the Process View, but those connections are actually still there.
I can kill them, and then they're gone. But why are they hanging on after the client has clearly disconnected?