Solved

Default database diagram

Posted on 2004-09-01
4
262 Views
Last Modified: 2010-05-18
I am upgrading from SQL7 to SQL 2000.  I have moved all the databases to SQL 2000.  Why can't I see the default database diagram in EM
0
Comment
Question by:chrisblay
  • 2
4 Comments
 
LVL 34

Expert Comment

by:arbert
ID: 11956664
Do you have the appropriate permissions?  There were diagrams on the original 7.0 server that should have upgraded?
0
 
LVL 15

Accepted Solution

by:
jdlambert1 earned 250 total points
ID: 11956730
>the default database diagram in EM

SQL Server doesn't automatically create diagrams...
0
 
LVL 34

Assisted Solution

by:arbert
arbert earned 250 total points
ID: 11956835
"SQL Server doesn't automatically create diagrams..."

But if there was a diagram called "Default" on the 7.0 server, it should be there now...
0
 

Author Comment

by:chrisblay
ID: 11956988
Thank you all for your help.  I finally fell on the answer.  If you right click the database, select view, Default database design; SQL 2000 will prompt to create the design.

Thanks again for your help
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to shrink a transaction log file down to a reasonable size.

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question