How to enable database diagram on SQL Server 2008

August 12, 2009

You have to enable database diagram on SQL Server, otherwise when you try to create a database diagram on SQL Server 2008, you are greeted with this message:

TITLE: Microsoft SQL Server Management Studio
——————————

Database diagram support objects cannot be installed because this database does not have a valid owner.  To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.

——————————
BUTTONS:

OK
——————————
So, first go to the database properties and select the Files tab. Select a valid login as the DB owner. Then go back to the Database Diagrams folder, right click and select Install Diagram Support. The next dialog show this message:

TITLE: Microsoft SQL Server Management Studio
——————————

This database does not have one or more of the support objects required to use database diagramming.  Do you wish to create them?

——————————
BUTTONS:

&Yes
&No
——————————
Click Yes.

Now go back and create a diagram.

 

 

tags: ,
posted in Blog by Magnus Johansson

Follow comments via the RSS Feed | Leave a comment | Trackback URL

5 Comments to "How to enable database diagram on SQL Server 2008"

  1. Ted wrote:

    Chingon… it works, thanks very much..

  2. Timothy wrote:

    Thank you very much. Exactly what I needed!

  3. Zohair Ahmed wrote:

    Thanks Its very use full for me…..

  4. hiển wrote:

    thanks

  5. kj wrote:

    thanks

Leave Your Comment

 
Powered by Wordpress and MySQL. Theme by Shlomi Noach, openark.org