SELECT DB_NAME(database_id) as [DB] , login_name , nt_domain , nt_user_name , status , host_name , program_name , COUNT(*) AS [Connections] FROM sys.dm_exec_sessions WHERE database_id > 0 -- OR 4 for user DBs GROUP BY database_id, login_name, status, host_name, program_name, nt_domain, nt_user_name;
Find who is connected to MS SQL.
Reply