Returns information about the connection properties for the unique connection that a request came in on.
CONNECTIONPROPERTY ( property )
Is the property of the connection. property can be one of the following values.
Returns the physical transport protocol that is used by this connection. Is not nullable.
Return values are: HTTP, Named pipe, Session, Shared memory, SSL, TCP, and VIA.
Always returns Session when a connection has multiple active result sets (MARS) enabled, and connection pooling is enabled.
Returns the protocol type of the payload. It currently distinguishes between TDS (TSQL) and SOAP. Is nullable.
Returns the SQL Server Authentication scheme for a connection. The authentication scheme is either Windows Authentication (NTLM, KERBEROS, DIGEST, BASIC, NEGOTIATE) or SQL Server Authentication. Is not nullable.
Returns the IP address on the server that this connection targeted. Available only for connections that are using the TCP transport provider. Is nullable.
Returns the server TCP port that this connection targeted if the connection were a connection that is using the TCP transport. Is nullable.
Asks for the address of the client that is connecting to this server. Is nullable.
Returns the physical transport protocol that is used by this connection. Accurate when a connection has multiple active result sets (MARS) enabled.
<Any other string>
Returns NULL if the input is not valid.
The values that are returned are the same as the options shown for the corresponding columns in the sys.dm_exec_connections dynamic management view. For example:
SELECT ConnectionProperty('net_transport') AS 'Net transport', ConnectionProperty('protocol_type') AS 'Protocol type'