How to Find SQL Server Database Owner & Creator

There are 2 ways of getting the SQL server database owner and creator. The first method is via the SQL query below,

##QUERY 1##
SELECT suser_sname(owner_sid) FROM sys.databases

##QUERY 2##
SELECT suser_sname(owner_sid) FROM sys.databases where name = 'DB_NAME'

##QUERY 3##
SELECT name AS 'Database', suser_sname(owner_sid) AS 'Creator' FROM sys.databases;

Alternatively, right click on the database name and select Properties.

Under General, look for the Owner tab and you will see the owner name there.

You May Also Like

Leave a Reply?