Este Script identificar os usuários que estão conectados na instância do SQL Server.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 |
SELECT session_id, login_time, host_name, program_name, client_interface_name, login_name, status, cpu_time, memory_usage, last_request_start_time, last_request_end_time, transaction_isolation_level, lock_timeout, deadlock_priority FROM sys.dm_exec_sessions WHERE login_name NOT IN (‘sa’, ‘AUTORIDADE NT\SISTEMA’, ‘NT AUTHORITY\SYSTEM’) |