Get net_address, hostname from:
select net_address, hostname
from master.dbo.sysprocesses
Get client_net_address from:
SELECT client_net_address
FROM sys.dm_exec_connections
Please help me get
net_address, hostname, client_net_address from 2 tables
sysprocesses, dm_exec_connections