Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

DATABASE Ownership Expand / Collapse
Posted Monday, January 28, 2013 2:37 PM


Group: General Forum Members
Last Login: Today @ 10:09 AM
Points: 134, Visits: 392
I need to change ownership of several production databases. Can I make the change without causing problems? The account that currently owns the database belongs to a user that no longer works here and his account is disabled. Now when I try creating a database diagram it says the owner is no longer valid among other problems

Any information about this issue would be appreciated.


Post #1412664
Posted Tuesday, January 29, 2013 8:45 AM



Group: General Forum Members
Last Login: Friday, November 20, 2015 5:28 PM
Points: 7,288, Visits: 13,148
If the owner's login is disabled in the instance then it can still successfully function as a database owner for things like cross-database ownership chains and such. Make sure none of that is in use before changing the owner. If the database owner is showing as NULL because the login is no longer present then changing the owner should not cause any issues.


There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1413097
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse