DATABASE Ownership

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » DATABASE Ownership

DATABASE Ownership

Rate Topic

Display Mode

Topic Options

Author

Message

jayoub1

Posted Monday, January 28, 2013 2:37 PM

Valued Member

Group: General Forum Members
Last Login: Saturday, May 18, 2013 6:32 PM
Points: 55, Visits: 152

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

opc.three

Posted Tuesday, January 29, 2013 8:45 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 4:02 PM
Points: 6,719, Visits: 11,754

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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1413097

« Prev Topic | Next Topic »

Permissions