Connection Details

ohhh look you can retrieve connection details using the sys.dm_exec_connections table linked to the connected users session ID @@SPID :)

SELECT * FROM sys.dm_exec_connections WHERE session_id = @@SPID