SELECT P.spid, P.login_time, P.last_batch, P.status, P.program_name, P.cmd, C.client_net_address
FROM sys.sysprocesses AS P INNER JOIN sys.dm_exec_connections AS C
ON P.spid = C.session_id
SELECT P.spid, P.login_time, P.last_batch, P.status, P.program_name, P.cmd, C.client_net_address
FROM sys.sysprocesses AS P INNER JOIN sys.dm_exec_connections AS C
ON P.spid = C.session_id