Query to find the sql authentication Scheme in SQL Server

--Query to find the sql authentication Scheme

SELECT auth_scheme FROM sys.dm_exec_connections WHERE session_id = @@spid

Recent Posts

-- Get logins that are connected and how many sessions they have SELECT login_name, COUNT(session_id) AS [session_count] FROM...

--Fix Orphan Users EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Auto_Fix', 'user' EXEC sp_change_users_login...