Search code examples
sql-serversql-server-2000ssmssql-server-2008

Unable to create database diagrams in SS 2000 using SSMS 2008

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? Thanks in advance for your help.

Solution

  • Versions of SQL Server later than 2000 cannot work with SQL Server 2000 diagrams.

    Here is some MSDN info on the subject.