USE MASTER GO SET NoCount ON DECLARE @VarDbId INT, @SQL nvarchar(4000), @VDBName nvarchar(260), @OUCounter INT, @Max_OUCounter INT SELECT @VarDbId=4, @SQL =” CREATE TABLE #OrphaneUsers ( ID INT IDENTITY (1,1) NOT NULL, DBName VARCHAR(125) NULL , UserName sysname NULL , UserSID VARBINARY(85) NULL , LoginExists bit NULL ) WHILE EXISTS (SELECT database_id FROM sys.databases WHERE database_id>@VarDbId … Continue reading Script to fix and list out Orphan Users on all the databases on server