eXtreme Programming
XP for the programmer
07 April 2016
Error when creating a Database diagram: Database owner is invalid
After restoring a database, I got an error when creating a Database diagram. Like the following image:
The error informs that the database owner is invalid.
The solution is to change to database owner using the sp_changedbowner.
To change the database owner for the sa user:
EXEC sp_changedbowner 'sa'
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment