Propriedades do servidor: IP, Server Name, Versão via SQL

Código para obter algumas propriedades de Conexão.

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,
CONNECTIONPROPERTY('physical_net_transport') as physical_net_transport,
@@SERVERNAME as server_name ,
host_name() as host_name,
@@VERSION as versao_sql

Podemos obter IP, nome do servidor e etc.