Who is connected via SQL DAC - SQL Snipplr Social Repository

Revision: 25474

at March 31, 2010 08:39 by tvanzele

Initial Code

SELECT dec.local_tcp_port AS DAC_Port,  des.login_name AS LoginName, des.nt_domain AS NTDomain,des.nt_user_name AS NTUserName, dec.session_id AS SPID,dec.connect_time AS ConnectTime, dec.last_read AS LastRead, dec.last_write AS LastWrite,des.host_name AS HostName, dec.client_net_address AS ClientIP, des.program_name AS AppName,e.state AS EndpointState, e.is_admin_endpoint AS IsAdminEndpoint
FROM sys.dm_exec_connections dec
JOIN sys.endpoints e ON e.endpoint_id = dec.endpoint_id
JOIN sys.dm_exec_sessions des ON des.session_id = dec.session_id
WHERE e.name = 'Dedicated Admin Connection'

Initial URL

Initial Description

Initial Title

Who is connected via SQL DAC

Initial Tags

sql

Initial Language

SQL

Choose a language for easy browsing: