Home Forums SQL Server 2008 SQL Server 2008 Administration 2008 R2 - ConnectionProperty system function is missing. RE: 2008 R2 - ConnectionProperty system function is missing.

  • August 21, 2017 at 1:55 pm

    #1956059

    I don't know that ConenctionProperty is actually database functionality . function. it's server functionality related to the connection, right?

    this works in SQL2008 and above, and  I just checked, and it doesn't get affected by compatibility level either:

    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'

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!