I've already tried sp_changedbowner, but as the user warehouse already exists - i get 'The proposed new database owner is already a user in the database.'

I will try your proposed method - thankyou