From the archives … To list database owners
SELECT name, SUSER_SNAME(owner_sid) owner
FROM sys.databases;
To change a database owner
USE SomeDatabaseName;
GO
EXEC sp_changedbowner notsa;
GO
To change ALL database owners
EXEC sp_msforeachdb
'USE [?]; IF db_id() > 4 EXEC sp_changedbowner notsa';
Database Consultant 