EvaldoMaciel

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

Apr 23rd, 2021 (edited)
61
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT Serverproperty('MachineName')                 AS ComputerName,
  2.        Serverproperty('ServerName')                  AS InstanceName,
  3.        Serverproperty('Edition')                     AS Edition,
  4.        Serverproperty('ProductVersion')              AS ProductVersion,
  5.        Serverproperty('ProductLevel')                AS ProductLevel,
  6.        Serverproperty('ComputerNamePhysicalNetBIOS') AS ComputerNamePhysicalNetBIOS,
  7.        CONNECTIONPROPERTY('net_transport')           AS net_transport,
  8.        CONNECTIONPROPERTY('protocol_type')           AS protocol_type,
  9.        CONNECTIONPROPERTY('auth_scheme')             AS auth_scheme,
  10.        CONNECTIONPROPERTY('local_net_address')       AS local_net_address,
  11.        CONNECTIONPROPERTY('local_tcp_port')          AS local_tcp_port,
  12.        CONNECTIONPROPERTY('client_net_address')      AS client_net_address
  13.  
  14.  
  15.  
RAW Paste Data