Consulta informações do banco de dados pela consulta SQL

SELECT Serverproperty('MachineName')                 AS ComputerName,
       Serverproperty('ServerName')                  AS InstanceName,
       Serverproperty('Edition')                     AS Edition,
       Serverproperty('ProductVersion')              AS ProductVersion,
       Serverproperty('ProductLevel')                AS ProductLevel,
       Serverproperty('ComputerNamePhysicalNetBIOS') AS ComputerNamePhysicalNetBIOS,
       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