SELECT dec.client_net_address , des.program_name , des.host_name , –des.login_nameĀ COUNT(dec.session_id) AS connection_count FROM sys.dm_exec_sessions AS des INNER JOIN sys.dm_exec_connections AS
Continue readingSELECT dec.client_net_address , des.program_name , des.host_name , –des.login_nameĀ COUNT(dec.session_id) AS connection_count FROM sys.dm_exec_sessions AS des INNER JOIN sys.dm_exec_connections AS
Continue reading