查看ip地址

来源:这里教程网 时间:2026-03-02 11:12:27 作者:
SELECT SERVERNAME = CONVERT(NVARCHAR(128),SERVERPROPERTY('SERVERNAME')) 
,LOCAL_NET_ADDRESS AS 'IPAddressOfSQLServer'
,CLIENT_NET_ADDRESS AS 'ClientIPAddress',*
 FROM SYS.DM_EXEC_CONNECTIONS 

相关推荐