主机名反查IP

适用于还连接着的主机名查询IP地址

 

SELECT distinct client_net_address as IP
FROM sys.dm_exec_connections
WHERE session_id in
(select   spid   from   master..sysprocesses
where hostname='jerrynet')

 

/*
 IP
 ------------------------------------------------
 <local machine>
 192.168.0.60

 (2 行受影响)

*/