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
Author
Message
Posted Monday, January 28, 2013 2:37 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 9:00 AM
Points: 103, Visits: 280
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
Post #1412664
Posted Tuesday, January 29, 2013 8:45 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 8:51 PM
Points: 7,140, Visits: 12,763
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.

ALTER AUTHORIZATION


__________________________________________________________________________________________________
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