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
chrisblayAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
jdlambert1Connect With a Mentor Commented:
>the default database diagram in EM

SQL Server doesn't automatically create diagrams...
0
 
arbertCommented:
Do you have the appropriate permissions?  There were diagrams on the original 7.0 server that should have upgraded?
0
 
arbertConnect With a Mentor Commented:
"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
All Courses

From novice to tech pro — start learning today.