Database diagram kills SSMS
When i want to open an existing diagram in SSMS 18.2 on a database which is on compativity level 100 SSMS closes and restarts immediately. I also tried it with a new diagram - this seems to work.
Thanks for reporting this issue.
Sadly, I am well aware of issues with Diagrams since I brought them back in SSMS 18… You should find another UserVoice item here with plenty of understandable upvotes (https://feedback.azure.com/forums/908035/suggestions/37992649).
Unfortunately, it is proving to be pretty complex to deal with this this ancient technology that is used by SSMS.
I found out a way to reproduce the problem. My database diagram had a space in the name. If I create a database diagram with no spaces I can open them again. I had originally named my database digram "dbo.Full Data Model".
After saving and closing I could no longer open "dbo.Full Data Model". I created the exact same model and named it "dbo.FullDataModel" then saved and closed it. I could open the one without spaces in the name.
I wonder if you're seeing the same behavior?
Having the same problem. Recent install of 18.2. Created a database diagram. Saved the diagram. Came back to work the next day. Attempted to open database diagram. SSMS closes immediately without warning. Unable to open any existing database diagrams. Seeing this with lvl 130.
Feature seems broken in SSMS.
I am not sure what is killed but I am experiencing the same issue. I have opened old database diagrams, reorganised tables, saved it and now I cannot open diagrams anymore as my Server Management Studio Crashes when I am trying to open those diagrams