Adi Cohn-120898 (1/7/2015)

---

This is one of the few times that cursor is helpful. You can create cursor for this SQL statement:

select 'kill ' + cast(session_id as varchar(20))

from sys.dm_exec_sessions

where host_name...

Adi Cohn-120898 (1/7/2015)

---

You can get all the sessions that came from a specific host by querying sys.dm_exec_sessions and get the value of session_id according to the value of column host_name....