Home > IT Answers > SQL Server > database ownership won’t accept login
Jsmaccready
15 pts.
 database ownership won’t accept login
AdventureWorksDW, Authorization, SQL Server 2005, SQL Server database diagram, SQL Server database ownership
I'm trying to assign an owner to AdventureworksDW so I may turn on database diagrams. Neither the GUI interface nor the 'Alter Authorization ...' method work. The sript approach reports success but whe reopened, the dialog still shows the property blank. Any ideas?

Software/Hardware used:
ASKED: October 20, 2008  5:51 PM
UPDATED: October 21, 2008  12:30 AM
RELATED QUESTIONS
Answer Wiki:
Use the sp_changedbowner procedure to change the owner of the database. <pre> USE AdventureworkdDW GO EXEC sp_changedbowner 'sa' GO</pre>
Last Wiki Answer Submitted:  October 21, 2008  12:30 am  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _