Post reply

Can't create database diagrams in SS 2000 using SSMS 2008

  • November 28, 2011 at 11:51 pm

    #252771

    I'm unable to create database diagrams in a SS 2000 database using SSMS 2008. I am a domain admin of a different domain than where my databases reside (the domain trust relationships are such that I have the same privileges in both domains). When I goto my 2000 database in SSMS and right click the database diagrams I see only "Working with SQL Server 2000 diagrams", "Reports", and "Refresh". My SQLServer instance is set to a compatibility of 80 (SQLServer 2000). Anyone have any ideas?

  • November 29, 2011 at 9:30 am

    #1414178

    You could try taking a backup of the SQL 2000 database and restoring it in a SQL 2008 instance, then changing the compatibility level to 100. Then you should be able to create the diagram in SSMS.

    Greg

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

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