January 28, 2013 at 2:37 pm
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.
Thanks
Jeff
Jeff
January 29, 2013 at 8:45 am
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply