MS Sql Server Cleanup

-- SQL CLEAN UP --

/* Find jobs still owned by ppl */
SELECT name,* 

FROM msdb..sysjobs

WHERE owner_sid = SUSER_SID('{USERNAME}')

exec msdb..sp_update_job
        @job_name = '{JOBNAME}',
        @owner_login_name = 'sa';


-- find database still owned

SELECT name, suser_sname(owner_sid) AS Database_Owner FROM sys.databases

--Change DBNAME with your database name--

USE {DATABASENAME}
GO
sp_changedbowner 'sa'