Saturday, August 25, 2012

v$session equivalent in sqlserver ,User Connected to SqlServer and Kill session

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

No comments:

Post a Comment

web stats