Re: Cannot View My Database Diagrams

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@xxxxxxxxxxxxxxxxxxxxxxxxx> 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.

------------------------------

.

Relevant Pages

  • Re: Report of the Best Practice Analyser
    ... the constraints will go as well. ... This table gets created when you create database diagrams in a database. ... > Vyas, MVP (SQL Server) ...
    (microsoft.public.sqlserver.tools)
  • Want to be able to create or view database diagrams
    ... Our MS SQL DBA has database privileges locked down ... create our own database diagrams. ...
    (comp.databases.ms-sqlserver)
  • Re: dt_getobjwithprop_u system procedure
    ... other resources that may have documented them in much ... Some are created when you access a database with Visual ... database using Visual Studio to get the details of what is ... >> database diagrams which are stored in dtproperties. ...
    (microsoft.public.sqlserver.server)
  • Re: Saving/Moving DTS packages
    ... Take the backup of MSDB database. ... How do I transfer DTS packages from one server to another? ... And, how do I transfer database diagrams from one server to another, or save ... > I have several DTS packages I'd like to archive somehow. ...
    (microsoft.public.sqlserver.server)
  • Moving databases from SQL 7 to SQL 2000 - More Questions!
    ... I know there are numerous threads with similar subjects in this newsgroup but there are a few of questions I need to ask and can't find answers for. ... I know that is won't copy DTS packages or database diagrams but there are other ways of doing this. ... Do I lose anything by not copying it? ...
    (microsoft.public.sqlserver.setup)