SCRIPT: How to get database owners and SQL Server Agent job owners

 -- Databases owners
SELECT
       d.name, l.name
FROM
       sys.databases AS d
       INNER JOIN sys.syslogins l
       ON l.sid = d.owner_sid
--WHERE
--     d.owner_sid <> 0x01
ORDER BY
       l.name

 

 

-- SQL Agent jobs owners
SELECT
    sj.name, l.name
FROM
       msdb.dbo.sysjobs AS sj
       INNER JOIN sys.syslogins l
       ON l.sid = sj.owner_sid
--WHERE
--     sj.owner_sid <> 0x01
ORDER BY
       sj.name