Jason.Reeves (8/27/2013)

---

Why would you be interested in the IP address if your using DNS and DHCP. Have a play with

SELECT

conn.session_ID as SPID,

conn.client_net_address as IPAddress,

sess.host_name as MachineName,

sess.program_name as ApplicationName,

login_name as LoginName

FROM sys.dm_exec_connections conn

inner join sys.dm_exec_sessions sess

on conn.session_ID=sess.session_ID

and triggers depending on the version of SQL you are using.