Data Base Diagrams ...

Hi,

I am relatively new to SQL 2005.
How do I create the Data Base diagrams of my existing data base in SQL 2005 ?

Thanks,
Abhijit Sinha

Using Management Studio, in Object Explorer, expand the database in the left pane.

Then right-click on [Database Diagrams] and select [New Database Diagram].

Follow the instructions.

|||Hey Arnie !

I think I should have been more specific. The data base I am talking about was created in SQL 2000. I am using SQL 2005 to view it. I need to create the DB diagrams from SQL 2005. When I right click on DB diagrams, all I get is
1. Working with SQL 2000 data base diagrams
2. Refresh

Clicking on option 1 takes me to the SQL help section which basically tells me that
"SQL Server Management Studio cannot work with SQL Server 2000 diagrams. Use SQL Server 2000 Enterprise Manager instead."

I was wondering if there is any work-around to this issue as I don't have SQL 2000 installed on my system.

Thanks,
Abhijit Sinha
|||OK, lets by a bit more specific.

YOu have a SQL Server SSMS 2005 Gui to manage your server, but you are administering a SQL Server 2000 with it. Then you cannot create a diagram on the SQL Server 2000. You will have to install Enterprise Manager 2000.

Jens K. Suessmeyer.

http://www.sqlserver2005.de