IP server desde SQL command

https://stackoverflow.com/questions/142142/sql-query-to-get-servers-ip-address

select @@version

SELECT  

   CONNECTIONPROPERTY('net_transport') AS net_transport,

   CONNECTIONPROPERTY('protocol_type') AS protocol_type,

   CONNECTIONPROPERTY('auth_scheme') AS auth_scheme,

   CONNECTIONPROPERTY('local_net_address') AS local_net_address,

   CONNECTIONPROPERTY('local_tcp_port') AS local_tcp_port,

   CONNECTIONPROPERTY('client_net_address') AS client_net_address 

Output

net_transport protocol_type auth_scheme local_net_address local_tcp_port

TCP                         TSQL     SQL         10.10.89.21         1433