Skip to content

Instantly share code, notes, and snippets.

@tayyebi
Last active February 25, 2017 18:47
Show Gist options
  • Save tayyebi/1a87011e52179ad03d04cbce14a2d446 to your computer and use it in GitHub Desktop.
Save tayyebi/1a87011e52179ad03d04cbce14a2d446 to your computer and use it in GitHub Desktop.
Get SQL Server connection properties
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
@tayyebi
Copy link
Author

tayyebi commented Feb 25, 2017

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment