In this article, we will see how to change the owner of database in SQL Server with different methods.
We following three methods to change SQL Server database owner name:
1. Using SQL Server Management Studio.
2. Using ALTER AUTHORIZATION command.
3. Using system stored procedure.
Permissions required to change owner of the database:
Requires TAKE OWNERSHIP permission on the database.
Change the owner of database in SQL Server using SSMS:
1. Right click on the database and select the properties
2. Then, go to files from left menu and click on browse button to change the owner name.
3. Then, provide the database name and click on Ok.
Change the owner of database in SQL Server using ALTER AUTHORIZATION command:
ALTER AUTHORIZATION ON DATABASE::training to [r2schools\administrator];ALTER AUTHORIZATION ON DATABASE::training to [r2schools\administrator];
Change the owner of database in SQL Server Using system stored procedure:
use training go EXEC sp_changedbowner 'sa' go