How to check authentication scheme in SQL 2005/SQL 2008?

You can use below query to check authentication scheme whether it is Kerberos or NTLM.

select auth_scheme from sys.dm_exec_connections where session_id=@@spid