I detached a SLQ 2000 database and reattached it in 2005 Developers.
When I try to access the Diagrams, the below message is received. My
domain account is owner. I'm local Admin on my machine. Shouldn't be
a problem right? How do I add the Database Diagram Support Objects?



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
------------------------------

I found this SQL Community / As a Question. Hope it helps someone out.

************************************************** **********


In SQL Server Management Studio do the following:

1. Right Click on your database, choose properties
2. Goto the Options Page
3. In the Dropdown at right labeled "Compatibility Level" choose "SQL
Server 2005(90)"
4. Goto the Files Page
5. Enter "sa" in the owner textbox.
6. Hit OK