Thursday, June 02, 2011

Find the all active user connections and internal tasks

SELECT * FROM sys.dm_exec_sessions
WHERE is_user_process =1
AND session_id <>@@SPID

No comments: