Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 285
  • Last Modified:

Default database diagram

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
chrisblay
Asked:
chrisblay
  • 2
2 Solutions
 
arbertCommented:
Do you have the appropriate permissions?  There were diagrams on the original 7.0 server that should have upgraded?
0
 
jdlambert1Commented:
>the default database diagram in EM

SQL Server doesn't automatically create diagrams...
0
 
arbertCommented:
"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
 
chrisblayAuthor Commented:
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now