Month: June 2022

SELECT name, SUSER_SNAME(owner_sid) owner 
FROM sys.databases;

USE SomeDatabaseName;
GO

EXEC sp_changedbowner notsa;
GO

EXEC sp_msforeachdb 
'USE [?]; IF db_id() > 4 EXEC sp_changedbowner notsa';