Solved

Default database diagram

Posted on 2004-09-01
4
233 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
Comment Utility
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
Comment Utility
>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
Comment Utility
"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
Comment Utility
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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

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 article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

763 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

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now