Liệt kê sanh sách người sử dụng truy cập database

SELECT ec.client_net_address, es.[host_name], DB_NAME(d.dbid) AS [DATABASE Name], es.Program_name, es.session_id FROM sys.dm_exec_sessions AS es INNER JOIN sys.dm_exec_connections AS ec ON es.session_id = ec.session_id INNER JOIN master..sysprocesses d ON es.session_id = d.spid GROUP BY ec.client_net_address, es.[host_name], d.dbid, es.Program_name, es.session_id ORDER BY es.[host_name], ec.client_net_address, d.dbid, es.Program_name, es.session_id