• shairal_t (6/2/2010)


    I have lots of databases that were created by several people - so they ended up being 'owned' by each of the creators. I would like (if possible) to have them all "owned" by the local admin account - not an individual. What should I look out for before I change the owner of these databases? I don't want anything to stop working in the name of conformity. Thanks!!

    As you mentioned,

    I assume that you want to change the "owner" of database, not the db_owner role, don't you?

    As far as i know, sql server have two "owner", one is the "owner" which is created when you create database and can not change, another one is the "db_owner" role which is assigned to user of sql server.

    So, if i'am right, i don't know how you can change the "owner" of database?

    Regards,

    Sol