Might be better ways, but this will do it:Declare @t TABLE (usr sysname)Declare @db sysnameDeclare c CursorRead_OnlyFOR SELECT name FROM sys.databases where state = 0 Open cFetch Next FROM c INTO @dbWHILE @@fetch_status = 0BEGIN INSERT @t SELECT s.name from sys.database_principals d join sys.server_principals s on d.sid = s.sid WHERE NOT EXISTS (SELECT usr FROM @t WHERE usr = s.name) Fetch Next FROM c INTO @dbENDCLOSE cDEALLOCATE cSELECT p.nameFROM sys.database_principals pLEFT JOIN @t tOn t.usr = p.nameWHERE t.usr IS NULLAnd p.principal_id > 5And p.type in ('U', 'S')