sp_changedbowner

sp_changedbowner is used to change the owner of a database. You can now execute it with either sa_role or sso_role privileges. The owner of thresholds for that database is also changed to the specified user.