--SQL Server 抓取连接的客户端IP地址:
DECLARE @IP_Address varchar(255);
SELECT @IP_Address = client_net_address
FROM sys.dm_exec_connections
WHERE Session_id = @@SPID;
SELECT @IP_Address AS N'客户端IP地址:';
--SQL Server 抓取连接的客户端IP地址:
DECLARE @IP_Address varchar(255);
SELECT @IP_Address = client_net_address
FROM sys.dm_exec_connections
WHERE Session_id = @@SPID;
SELECT @IP_Address AS N'客户端IP地址:';