Techie's World
Interesting aspects that I come across.
Pages
Blog
About me.
30 Apr 2012
MSSQL Management Studio: Database Diagram problem.
Recently I got an error message in Management Studio with database diagram. Error message is
To solve this:
Right Click on interested database, choose properties
Goto the Files Page
Enter "sa" in the owner textbox.
Save changes.
Alternative (haven't tried yet) is to give privilege by
ALTER AUTHORIZATION ON DATABASE::YourDatabaseName TO sa
GO
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment