SP_CHANGEDBOWNER Error Msg 15110

Msg 15110, Level 16, State 1, Line 1
The proposed new database owner is already a user or aliased in the database.

The error message gives a hint at what is wrong.  The user is already present.  So, let's delete (drop) the user and then change the owner back to the user we really want to be the owner of the database. 


USE YourDB
GO
SP_DROPUSER ‘The_User’ — Drop The_User 
GO
SP_CHANGEDBOWNER ‘The_User’ — Change the owner