본문 바로가기
MS-SQL

[#9] Mac Address 및 IP Address 확인 Query

by 김뽀씨 2013. 6. 17.

----------------------------------------------------------------

[쿼리]

SELECT A.NET_ADDRESS, B.CLIENT_NET_ADDRESS
FROM SYS.SYSPROCESSES AS A, SYS.DM_EXEC_CONNECTIONS AS B
WHERE A.SPID = B.SESSION_ID AND A.SPID = @@SPID

----------------------------------------------------------------