database diagrams

Using SQL 2005, I am not able to access existing database diagrams created i
n
SQL 2000. It tells me there is no valid owner for the database and can not
install the diagram support objects. The database properties say SA is the
owner and that is also how I am connected. I have tried everything I can
think of to get to the diagrams.
Any help would be appreciated.You need to set the database compatibility level of the database to 90. You
can do this by running the following statement, or by selecting the
Properties page of the database in SQL Server Mangement Studio.
EXEC sp_dbcmptlevel <database_name> , 90
This is documented in the readme, but is easy to miss. The Books Online
topics on database diagrams will be updated with this information in the
April download of BOL.
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"Richard Kohler" <Richard Kohler@.discussions.microsoft.com> wrote in message
news:EDC8EBA9-E131-4553-B965-82FE1AD38CA7@.microsoft.com...
> Using SQL 2005, I am not able to access existing database diagrams created
> in
> SQL 2000. It tells me there is no valid owner for the database and can not
> install the diagram support objects. The database properties say SA is the
> owner and that is also how I am connected. I have tried everything I can
> think of to get to the diagrams.
> Any help would be appreciated.|||That worked! Thank you for your quick reply.
"Gail Erickson [MS]" wrote:

> You need to set the database compatibility level of the database to 90. Y
ou
> can do this by running the following statement, or by selecting the
> Properties page of the database in SQL Server Mangement Studio.
> EXEC sp_dbcmptlevel <database_name> , 90
> This is documented in the readme, but is easy to miss. The Books Online
> topics on database diagrams will be updated with this information in the
> April download of BOL.
> --
> Gail Erickson [MS]
> SQL Server Documentation Team
> This posting is provided "AS IS" with no warranties, and confers no rights
> "Richard Kohler" <Richard Kohler@.discussions.microsoft.com> wrote in messa
ge
> news:EDC8EBA9-E131-4553-B965-82FE1AD38CA7@.microsoft.com...
>
>