메뉴 건너뛰기

kode2.com

MSSQL dm_exec_connections

2019.02.16 16:04

kode2 조회 수:62

MSSQL Connections Info , Local IP, Remote IP

 

SELECT dec.local_net_address,*
FROM sys.dm_exec_connections AS dec 
WHERE dec.session_id = @@SPID;

 

SELECT SERVERPROPERTY(N'MachineName');