Marc Valk dot Net

SELECT     s.session_id,     c.connect_time,     s.login_time,     s.login_name,     c.protocol_type,     c.auth_scheme,     s.HOST_NAME,     s.program_name FROM sys.dm_exec_sessions s JOIN sys.dm_exec_connections c ON s.session_id = c.session_id   A query to see if a connection is made with Kerberos or NTLM. login_name together with host_name and program_name will identify the login. auth_scheme will reflect what [...]