MSSQL dm_exec_connections
2019.02.16 16:04
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');
2019.02.16 16:04
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');