Home Forums SQL Server 2005 Administering The proposed new database owner is already a user or aliased in the database RE: The proposed new database owner is already a user or aliased in the database

  • thanks Manu,

    But after changing the owner to abc\btsadmin, I want to have the below database roles (these roles already exist now, with database owner SA and I want to keep them as it is after changing the owner to abc\btsadmin)

    db_accessadmin

    db_ddladmin

    db_securityadmin

    public

    please see the attachment