When trying to add a diagram to an SQL Server 2005 db I got the following error:
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.
In SQL Server Management Studio do the following:
Right Click on your database, choose properties
Goto the Options Page
In the Dropdown at right labeled "Compatibility Level" choose "SQL Server 2005(90)"

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=228352&SiteID=1

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.