Has anyone seen a book that is decent in regards to this?

Has anyone else seen this problem?

The spid did not begin rollback and was not affected at all. We stop all the processes on the app server so it wasn't trying to reconnect.

The problem is that I couldn't kill any fo the processes. They were all database spids coming from an application server.

Even after I shutdown all the application servers I could...

Thank you for the information on the MSSQLServer service. The issue I have is that the switch has issues mapping multiple IPs to a single MAC. In addition...