Post reply

Database diagrams

  • July 18, 2008 at 6:59 am

    #210174

    Hi there,

    I am trying to create DB diagrams in SSMS. The DB is from sql server 2000 i.e. its compatibility level =80.

    When I tried to create DB diagrams, i get following (this is from BOL)

    "SQL Server 2005 database diagrams and SQL Server 2000 database diagrams are created and rendered differently. Because of these differences, SQL Server Management Studio cannot work with SQL Server 2000 diagrams. Use SQL Server 2000 Enterprise Manager.

    When a database containing diagrams is upgraded to SQL Server 2005, the diagrams will be upgraded the first time that the diagrams folder is opened.

    You must be a member of the db_owner database role to upgrade database diagrams."

    Is this the only solution to the problem? Because, I am not member of db_owner role... I can't proceed by changing compatibility level.

    Thanks,

  • July 18, 2008 at 10:28 am

    #845159

    you can get and install the client tools for sql 2000 (Enterprise manager)

    It can be installed along side SQL management Studio.

    Then use Enterprise Manager instead of SMS to interact with the diagrams.

  • July 18, 2008 at 12:00 pm

    #845197

    Ok, thanks.

    I will try that.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply