none
Data Base Diagrams ...

    Question

  • 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
    Tuesday, June 19, 2007 8:41 AM

Answers

  • 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
    ---

    Friday, June 22, 2007 1:02 PM
    Moderator

All replies

  • 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.

    Tuesday, June 19, 2007 3:45 PM
    Moderator
  • 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
    Wednesday, June 20, 2007 4:33 AM
  • 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
    ---

    Friday, June 22, 2007 1:02 PM
    Moderator