TSQL - Current connections

SELECT

       *

FROM

       sys.dm_exec_connections

;