CODEWITHSUNDEEP
sql-server
5YrsLaterDBA
5YrsLaterDBA

Reputation: 34830

How to create database diagrams in SQL Server 2008 express?

I am using SQL Server 2008 express version but don't know how to generate database diagrams. When I click the Database Diagrams, it give me an error diagram tell me "Database diagram support objects cannot be installed because this database does no thave a valide owner. ...." I follow its instruction and cannot find anything wrong. Anybody can help me about this?

Anybody can recommend a free database design tool I can use with SQL Server to create ER diagram for our existing database?

Upvotes: 0

Views: 3668

Answers (1)

Mitch Wheat
Mitch Wheat

Reputation: 300797

You need to change the compatibility level and set authorisation:

Database diagram support objects cannot be installed

Upvotes: 1

Related Questions