sqlserver select IP address - AichaelLee/Summary GitHub Wiki

SELECT client_net_address as a1, local_net_address as a2
FROM sys.dm_exec_connections
WHERE session_id = @@SPID