Make a login into dbo for a database in SQL Server -
i attempting migrate sql server 2005 sql server 2008. both of these database instances hosted on 3rd party shared servers not have full permissions to. using mixed mode authentication. i running trouble setting new database same way old 1 set up. specifically, new web-based control panel doesn't allow dbo specified when creating new database , when using red gate sql compare sync schemas having problems because objects (that don't explicitly specify dbo in script) being created prefix of user account rather dbo. i have poured on documentation trying find way force login "user1" dbo "db1" database. came conclusion script should this: alter authorization on database::db1 user1 before running script, login "user1" exists, not user database "db1". note had submit script support of hosting company in order run it. according hosting company statement executes, when compare databases using sql compare user "user1" has not b...