Cannot View My Database Diagrams

I recently reinstalled Visual Studio and SQL Server 2005 Developer Edition
onto a new (larger) hard drive and so far everything has been working as
before for my database, but when I went to view my database diagrams, I am
now getting this message. I tried as the message suggested to change the
database owner, but this only results in error messages. Neither can I add
any new database diagrams.
Anyone have any ideas as to how to solve such a problem?
Thanks,
Paul
---
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.What is the compatibility mode of the database?
You can check with:
select compatibility_level
from sys.databases
where name = 'YourDatabase'
It needs to be at 90 to use the diagrams. I think this was
fixed in the service pack so the other alternative is to
apply SP1.
-Sue
On Tue, 17 Oct 2006 08:37:01 -0700, a
<a@.discussions.microsoft.com> wrote:

>I recently reinstalled Visual Studio and SQL Server 2005 Developer Edition
>onto a new (larger) hard drive and so far everything has been working as
>before for my database, but when I went to view my database diagrams, I am
>now getting this message. I tried as the message suggested to change the
>database owner, but this only results in error messages. Neither can I add
>any new database diagrams.
>Anyone have any ideas as to how to solve such a problem?
>Thanks,
>Paul
>---
>
>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.
>--