sql server new users: A database that was moved from SQL Server 2000 to 2005 displays the
following message when Database Diagrams is selected from within SQL Server
Management Studio:

"Database diagram support objects cannot be installed because the 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 se
the database owner to a valid login, then add the database diagram support
objects."

The database was originally set up to recognize a network loginID. The
Properties dialog box shows the owner as the domain\loginID. What do I need
to change it to so that I can use the diagramming features?

Thanks,

Keith

Hello Keith,

I see from your previous posts that you've found the answer to your own
question about there being a way to graphically design FK relationships
and the like (the DB Diagram functionality in Management Studio). To
answer your other questions:

1) In my experience both Management Studio Express & Management Studio
Standard have the functionality to produce database diagrams

2) You said in this post that the DB was moved from SQL Server 2000 to
SQL Server 2005. I believe that this is the root cause of your issues
with diagramming.

You should check the compatability level of your database (view the
database's properties and look on the "Options" page...there should be
a value for the compatability).

In order for diagramming to work the compatability must be SQL Server
2005 (90). I believe, from what you've described, that the
compatability for your DB is only SQL Server 2000 (80). If you set
compatability to SQL Server 2005 your problems should be resolved.

Hope that helps.

[quoted text, click to view]

Please see the Important note in this Books Online topic:
http://msdn2.microsoft.com/en-us/library/ms189279(SQL.90).aspx
Regards,
Gail
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights

[quoted text, click to view]