Changing DB owner from Kate to Bob, but Kate owns objects

[kim]

Im having trouble changing the DB owner from Kate to Bob, because Kate owns some objects in the DB.
I first try to run sp_changedbowner Bob....but it tells me:
The proposed new database owner is already a user in the database.

When I run scripts on a table that such as;
sp_changeobjectowner 'customers', 'Bob'...I get the message of

Server: Msg 15001, Level 16, State 1, Procedure sp_changeobjectowner, Line 38
Object 'customers' does not exist or is not a valid object for this operation.

Please help with what I can do.

Thank you

[MAK]

you should use sp_changeobjectowner 'kate.customers','bob'

[rmiao]

You have to drop user bob first, it's ok for kate to own objects in the db.

[kim]

ok, got it..thank you