Skip to content

Instantly share code, notes, and snippets.

@matejskubic

matejskubic/mssql-connections-details.sql

Created December 23, 2015 10:04
Show Gist options
  • Save matejskubic/4410217d4f93e1cf5d42 to your computer and use it in GitHub Desktop.
Save matejskubic/4410217d4f93e1cf5d42 to your computer and use it in GitHub Desktop.
Download ZIP
SQL Server connections details
Raw
mssql-connections-details.sql
select b.spid, b.hostname, b.program_name, a.net_transport, a.auth_scheme
from sys.dm_exec_connections a
inner join sys.sysprocesses b
on a.session_id = b.spid
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment