Question: how to change the owner of the database in sql server?
Answer: Open SQL Server Management Studio (SSMS).
Right click on the Database, then select Properties.
Click on Files. The following screenshot will appear.
If we want to change the database owner, click on the ellipsis button to select the new owner.