NEWBIE: How to change owner of db to an existing table owner?
Posted on 2006-03-27
Dear MS SQL Experts,
I want to make "Bob" the owner of a database, in which "Bob" is already the owner of tables in the database, and "Bob" also has all available authorities over the database. When I try:
EXEC sp_changedbowner 'Bob;
I get this error:
Server: Msg 15110, Level 16, State 1, Procedure sp_changedbowner, Line 46
The proposed new database owner is already a user in the database.
Is there an easy way to make this happen?