T-SQL to kill ALL sessions for a Login
There will be cases when a particular user has created some chains of processes and those processes needs to be killed. Searching and kill all the session if they are more is bit a tidious task. Below is the simple query will give you the Kill command for all session for a particular login.
select 'Kill '+cast(spid as varchar(10)) from sysprocesses where loginame = 'LoginNameSessionToBeKilled'