MS-SQL
[#9] Mac Address 및 IP Address 확인 Query
김뽀씨
2013. 6. 17. 13:42
----------------------------------------------------------------
[쿼리]
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
----------------------------------------------------------------