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