Is there a way to check the authentication sheme (NTLM/Kerberos) for the current session in SQL 2000 ?
Below query is for SQL 2005 onwards. Is there a query to achieve similar results in SQL 2000
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