Pages

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:


  1. Right Click on interested database, choose properties
  2. Goto the Files Page
  3. Enter "sa" in the owner textbox.
  4. 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