-- Script to check the orphan user EXEC sp_change_users_login 'Report' --Use below code to fix the Orphan User issue DECLARE @username varchar(25) DECLARE fixusers CURSOR FOR SELECT UserName = name FROM sysusers WHERE issqluser = 1 and (sid is not null and sid <> 0x0) and suser_sname(sid) is null ORDER BY name OPEN fixusers FETCH NEXT FROM fixusers INTO @username WHILE @@FETCH_STATUS = 0 BEGIN EXEC sp_change_users_login 'update_one', @username, @username FETCH NEXT FROM fixusers INTO @username END CLOSE fixusers DEALLOCATE fixusers
Sunday, October 6, 2024
Fix Orphan User Settings in SQL server
Subscribe to:
Post Comments (Atom)
DBA discussion
Here is a detailed prompt for creating a database administrator (DBA) automation tool. This prompt can be used with GitHub Copilot, ChatGPT...
-
Create Login, User, assign Permission: SQL Server Tutorial ---LOGIN IS THE 3 STEPS PROCESS - --CREATE LOGINS --- CREATE USERS --- SET PER...
-
Link Server:- A linked server allows joining several SQL Server instances using a single T-SQL statement when data exists on multiple datab...
-
SELECT 'ALTER INDEX ALL ON [' + Table_schema + '].[' + Table_name + '] REBUILD;' FROM information_schema.tables WHE...
No comments:
Post a Comment
Thanks For Visit