blogging about…… Microsoft, Cloud Computing and all other things I find interesting
In: SQL Server|Security
10 Apr 2009SELECT 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 [...]