CODEWITHSUNDEEP
sql-serversql-server-2000ssmssql-server-2008
5lb Bass
5lb Bass

Reputation: 539

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.

Upvotes: 1

Views: 1027

Answers (2)

trevor
trevor

Reputation: 267

Is it possible that you are using SSMS version 18.0 ?

Relationship diagrams feature is missing from that version.

Install 17.9 or 18.1 to get the diagrams to work.
Note that you must uninstall a previous version of SSMS to install a new one.

Upvotes: 0

competent_tech
competent_tech

Reputation: 44921

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

Here is some MSDN info on the subject.

Upvotes: 1

Related Questions