How to change SQL Server DB Owner ?
Hi People,
I've got a several SQL Server database which is owned by DOMAIN\Administrator, I'd like to change it to the respective person associated with their Application DB eg. DOMAIN\Person1
so how can I change the DB Owner for the database without causing problem or downtime for the production database in SQL Server 2008 and 2005 ?
Thanks.
I've got a several SQL Server database which is owned by DOMAIN\Administrator, I'd like to change it to the respective person associated with their Application DB eg. DOMAIN\Person1
so how can I change the DB Owner for the database without causing problem or downtime for the production database in SQL Server 2008 and 2005 ?
Thanks.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>>hopefully it can swap the DB Owner without needing restart or DB attach detach. <<
Not need to restart, let alone detach/attach. It should take less that 5 seconds to complete and no one will be the wiser.
Not need to restart, let alone detach/attach. It should take less that 5 seconds to complete and no one will be the wiser.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Fair enough. So why don't you post the solution using ALTER AUTHORIZATION, rather than parroting what you read in SQL Server's BOL?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Very good point.
ASKER
hopefully it can swap the DB Owner without needing restart or DB attach detach.