廣度與深度

這段sql 可以看出現階段登入的user 跟 SQL 上在執行的sql 碼 

SELECT A.session_id,A.login_name,c.text AS 'TSQL語法',A.login_time,A.original_login_name,B.auth_scheme,

A.host_name,A.program_name,A.client_interface_name,A.login_name, 

A.nt_domain,A.nt_user_name,A.status,A.cpu_time,

A.total_elapsed_time,A.total_scheduled_time,B.client_net_address,B.client_tcp_port,

B.local_net_address,B.local_tcp_port,C.dbid,c.objectid,

CASE 

WHEN c.encrypted=0 THEN '未加密'

WHEN c.encrypted=1 THEN '資料加密'

ELSE '未知加密狀態'

END

FROM sys.dm_exec_sessions A INNER JOIN sys.dm_exec_connections B ON A.session_id=B.session_id

CROSS APPLY sys.dm_exec_sql_text(B.most_recent_sql_handle) C

Order by login_time desc

go