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