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_id
ORDER BY 3,1