Microsoft provides system stored procedures (dbo.sp_changedbowner) for changing the db owner. Keep in mind, a user database should have a db owner associated with it; dont mis interpret this witj db_owner role. I personally prefer setting the db owner to ‘sa’ 1 2SELECT NAME, 3 suser_sname(owner_sid) AS 'owner', 4 CASE...