Problem

Changes job ownership for Active Directory/Windows logins (excludes sql logins) to SA while keeping a record of the previous owner using database extended properties.

Solution

https://github.com/steverezhener/DBA/blob/master/Procedures/bestpractices.usp_change_database_owner_to_db_owner.sql