SELECT login_name,session_id
FROM sys.dm_exec_sessions
go
For kill Session
select login_name, session_id, host_name from
FROM sys.dm_exec_sessions ;
KILL SESSION_ID
go
FROM sys.dm_exec_sessions
go
For kill Session
select login_name, session_id, host_name from
FROM sys.dm_exec_sessions ;
KILL SESSION_ID
go