,c.local_net_address , A.hostname, A.loginame, B.name, A.program_name
from master..sysprocesses A
, sys.databases B
, sys.dm_exec_connections c
where A.dbid = B.database_id
and
A.sql_handle = c.most_recent_sql_handle
and client_net_address not in('
group by c.client_net_address
,c.local_net_address , A.hostname, A.loginame, B.name, A.program_name
