Change Login user when login user is dbo

Question

I have a problem with login users like as below picture . I want to change user of domain login on MessageSender and FAQ database from [dbo] to [Anyuser] . I get error when use sp_change_users_login procedure for change login's user . Error is : Terminating this procedure. 'dbo' is a forbidden value for the login name parameter in this procedure.

Quession is :
How I can change login (Domain\Login) user from [dbo] to [Domain\Login] ?

Answer 1

I use this query : and solve the problem

ALTER AUTHORIZATION ON DATABASE::[MessageSender] TO [sa];