SELECT dc.session_id AS [SPID] ,dc.client_net_address AS [IP клиента] ,sp.hostname AS [Имя PC клиента] ,dc.local_net_address AS [IP подключения к серверу] ,dc.net_transport AS [Протокол подключения] ,dc.local_tcp_port AS [Порт] ,sp.[program_name] AS [Имя программы] ,sp.loginame FROM sys.dm_exec_connections dc INNER JOIN MASTER.sys.sysprocesses sp ON dc.session_id = sp.spid WHERE sp.spid