Applies To: SQL Server 2014, SQL Server 2016 Preview
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
Returns information about the connection properties for the unique connection that a request came in on.
Applies to: SQL Server (SQL Server 2008 through current version), SQL Database V12.
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.