Query to find the sql authentication Scheme in SQL Server
Kunal Ranpura- Jul 28, 2019
- 1 min read
--Query to find the sql authentication Scheme
SELECT auth_scheme FROM sys.dm_exec_connections WHERE session_id = @@spid
top of page
bottom of page
--Query to find the sql authentication Scheme
SELECT auth_scheme FROM sys.dm_exec_connections WHERE session_id = @@spid
-- 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...
Comments