Re: Database Diagrams

Thanks Gail!
--
Michael Hockstein


"Gail Erickson [MS]" wrote:

In addition to Erland's response, you can also find the readme here:
http://support.microsoft.com/default.aspx?scid=kb;en-us;910228
Also, the April update to Books Online will contain this information in the
various topics on database diagrams.
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights

"michael" <howlinghound@xxxxxxxxxxxxx> wrote in message
news:4885DE6E-B80F-4367-9B2E-D772F090CD7B@xxxxxxxxxxxxxxxx
Fantastic. Worked like a charm. Could you also give me a clue as to where
to
find the Readme file? I looked in the SQL Server directory and subs but
couldn't locate it. This would be a good one to keep on file.


--
Michael Hockstein


"Gail Erickson [MS]" wrote:

This is covered in section 4.8 in the Readme file that comes with the
product .
To install database diagram support in SQL Server Management Studio,
databases must be in SQL Server 2005 database compatibility level.
Database
compatibility level can be reset after diagram support is installed. To
create database diagrams, change the database compatibility level to
2005,
install database diagram support, and then return the database to the
desired database compatibility level. For more information, search for
"sp_dbcmptlevel" in SQL Server Books Online.

So, run the following statement and try the diagram again.

EXEC sp_dbcmptlevel database_name, 90

--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no
rights

"michael" <howlinghound@xxxxxxxxxxxxx> wrote in message
news:EB3D155A-EC71-4854-BAC6-7B14BE038586@xxxxxxxxxxxxxxxx
I have a SQL 2000 database that I imported into SQL Server 2005 by
restoring
the database from a backup. I carefully re-did the Users to make sure
there
were corresponding Logins.

I want to create a Database Diagram using the Microsoft SQL Server
Management Studio. When I right click on the Database Diagrams node
within
the correct database I get the following error.

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 ALTE AUTHORIZATION statement to
set
the
database owner to a valid login, then add the database diagram support
objects.

Now I did both of these suggestions and then looked at the owner of the
database, who in fact is a valid Login with sysadmin privileges.

I'm not sure where to go from here since everything seems to be done
correctly.

Any suggestions?
--
Michael Hockstein






.

Relevant Pages

  • Re: SQL 2005 dbo user issue
    ... While it may appear that the database diagram tool in SQL Server 2005 is the ... "To install database diagram support in SQL Server Management Studio, ...
    (microsoft.public.sqlserver.security)
  • Re: Cannot Open SQL Server Table in Access.ADP File.
    ... (SQL Server Import and Export Wizard) ... I understand that you'd like to script out database diagram. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Database Diagrams
    ... SQL Server Documentation Team ... To install database diagram support in SQL Server Management Studio, ...
    (microsoft.public.sqlserver.tools)
  • Re: Table design exportation
    ... In order to launch the Database Diagram component, ... Launch Enterprise Manager from the Start> Programs> Microsoft SQL Server ...
    (microsoft.public.sqlserver.tools)
  • Re: Database Diagrams
    ... To install database diagram support in SQL Server Management Studio, ...
    (microsoft.public.sqlserver.tools)
Loading