You can run sp_changedbowner to change
ownership to a temporary login and then run sp_changedbowner
and to change the ownership to sa and drop the temporary
login you used.
On Fri, 8 Mar 2002 06:51:28 -0800, "kyleo"
>SA isn't the owner of the database but we need to make it
>the owner. When I run the sp_changedbowner 'sa' against
>the database, I get the message 'the proposed new database
>owner is already a user in the database'. Anyone ever run
>into this issue before?