Kunal RanpuraJul 30, 20191 minFind number of session for each SQL Server Login Connected-- Get logins that are connected and how many sessions they have SELECT login_name, COUNT(session_id) AS [session_count] FROM...
Kunal RanpuraJul 28, 20191 minQuery 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
Kunal RanpuraJul 28, 20191 minFix Orphan User--Fix Orphan Users EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Auto_Fix', 'user' EXEC sp_change_users_login...