Manage Database Owners

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';

Leave a comment