In this article, we will see how to find the owner of database in SQL Server using two methods.
1. Using GUI
2. Using SQL Statement.
Find the owner of database name in SQL Server using SSMS.
1. Right click on the database and select the properties
2. Then, go to files from left menu. There is option owner as highlighted below.
Find the owner of database name in SQL Server using SQL: Statement.
select suser_sname(owner_sid) from sys.databases where name = 'training';