Can you have more than one db owner?

Who is the owner of a database?

The term database owner refers to the current authorization identifier when the database is created, that is, the user creating the database. If you enable or plan to enable SQL authorization, controlling the identity of the database owner becomes important.

How do I change a database owner in South Africa?

use [DemoDatabase]; exec sp_changedbowner [sa]; use [EltechDB]; exec sp_changedbowner [sa]; Execute the above query in our SQL Server instance and see how it changes the database owner to sa login. Once the command executes successfully, run the below query to verify that the database owners have been changed.

Can we have more than one database with same name?

You cannot have 2 databases or two named instances with same name. System databases cannot be detached and attached.

How do you change the owner of a database?

Go to SQL Server Management Studio >> Right Click on the Database >> Go to Properties >> Go to Files and select OWNER. You can see the following screenshot which describes how to do the same task. Do let me know when was the last time you needed to change the owner of the database and which method did you use to do so?