Change the owner of the database

[reddy]

Hi All,

I want to change the OWNER of the database to 'sa' and I executed the
following system stored procedure

EXEC sp_changedbowner 'sa'

and I get the following error message..

Server: Msg 15110, Level 16, State 1, Procedure sp_changedbowner, Line 46
The proposed new database owner is already a user in the database.

Any ideas
Thanks
Reddy

[Jim W]

Um, who is the current owner of the database?

Do the following queries:

select sid from master.dbo.sysdatabases where name = "mydbname"

select * from master..syslogins where name = 'sa'

If the sid of the first query matches the sid of the second query, sa is already the owner.

Also, that stored procedure you are trying to run should NOT be run for sa, since you would have to remove sa as a user in the database first.

Go edit the 'sa' user login, click on the database access, and make sure that sa has db_owner in each of the databases.


------------
reddy at 1/10/01 4:41:32 PM

Hi All,

I want to change the OWNER of the database to 'sa' and I executed the
following system stored procedure

EXEC sp_changedbowner 'sa'

and I get the following error message..

Server: Msg 15110, Level 16, State 1, Procedure sp_changedbowner, Line 46
The proposed new database owner is already a user in the database.

Any ideas
Thanks
Reddy