Unanswered: Upgrade from 2000 to 2005 Express made my diagram inaccessible...
I have a database that has been working sweetly for over a year, an Access front end with an SQL Server 2000 back end. No problems.
Then the IT trolls came along and "upgraded" the SQL Server to 2005 Express. Sounds good, but prior to the update I had an ERD (Diagram). Now I'm no SQL Guru, so I rely on the diagram to create relationships and for referencing while coding.
The SQL Server 2005 Express version holds the tables and everything ok, but there is no diagram and I read up in help and find that the diagrams are incompatible. I read that I have to somehow update it to "2005 compatibility". When I use the interface I find a compatibility option which has SQL Server 7 and SQL Server 2000, but not SQL Server 2005. I'm now kinda stuck.
How can I recover the ERD diagram or at least be able to create a new one in 2005 Express??