sqlserver 2005 查看客户端IP

SELECT TOP 10 a.spid /*进程ID*/, a.loginame /*用户*/, db_name(a.dbid) AS dbname /*数据库*/, a.status /*状态*/, a.open_tran /*打开事务数*/, a.blocked /*阻塞者*/, (SELECT CASE WHEN count(1)>0 THEN 1 ELSE 0 END from sys.sysprocesses c WITH (nolock) WHERE a.spid = c.blocked AND c.blocked>0) AS blocking /*阻塞*/, a.cmd /*命令*/, a.program_name /*应用程序*/, CASE WHEN a.waittime=0 THEN 0 ELSE a.waittime / 1000 / 60 END AS waittime /*等待分钟数*/, a.lastwaittype /*等待类型*/, a.waitresource /*等待资源*/, a.hostname /*客户端名称*/, b.client_net_address AS host_ip /*客户端IP*/from sys.sysprocesses a WITH (nolock)  , sys.dm_exec_connections b WITH (nolock) WHERE a.spid = b.session_idORDER BY 3,1