Database Diagrams Error - SQL Server 2005

Hello Friends,

Most of our friends will receive the below error message when they are trying to create a database diagram. This will happne when the database

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.

This is covered in section 4.8 in the Readme file that comes with the product .To install database diagram support in SQL Server Management Studio, databases must be in SQL Server 2005 database compatibility level. Database compatibility level can be reset after diagram support is installed. To create database diagrams, change the database compatibility level to 2005, install database diagram support, and then return the database to the desired database compatibility level. For more information, search for "sp_dbcmptlevel" in SQL Server Books Online.So, run the following statement and try the diagram again.

EXEC sp_dbcmptlevel database_name, 90

I happened to have the SQL 2005 server DVD in my player, and I found aReadme in G:\SQL Server x86\Servers\ReadmeSQL2005.htm. There seem to beone in every top-level setup directory.

In addition to Erland's response, you can also find the readme here: http://support.microsoft.com/default.aspx?scid=kb;en-us;910228Also, the April update to Books Online will contain this information in the various topics on database diagrams.