SELECT conn.session_id, DB_NAME(database_id) as [DB], host_name, connect_time, net_transport FROM sys.dm_exec_sessions AS sess JOIN sys.dm_exec_connections AS conn ON sess.session_id = conn.session_id where DB_NAME(database_id)='at20' and net_transport='TCP'It shows data like shown in attachment 1