AdventureWorks Database - cannot access Database Diagrams

Hi,

When I try to access the database diagrams in AdventureWorks, I get the following message:

TITLE: Microsoft SQL Server Management Studio Express

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

Why is this?

All advice / help apprecuated.

Thanks

hi,

after "upgrading" a database from MSDE or installing AdventureWorks database, you have to access the database properties window and set the database owner to a registered login... for upgraded dbs you have to modify the compatibility level to 90 as well..
you can then access the Diagrams window..

upgraded database should have the statistics rebuilt as well WITH FULL SCAN..

DBCC CHECKDB WITH DATA PURITY should be performed as well as upgraded database do not have the "column's level values checked" by default...

regards