Have you ever wanted to check which method you are using to authenticate to a SQL backend?   Just run the following SQL to return the current authentication scheme your user context is using.SELECT session_id, auth_scheme FROM sys.dm_exec_connections WHERE session_id=@@spidYou can easily modify the above to give you the authentication schemes for all connections by dropping the where clause.