SSMS 18 has Stopped Working when attempting to <Right-Click> on an Entity in SQL Server Management Studio

Bobby P 231 Reputation points
2022-12-02T19:10:46.417+00:00

Soooo sometimes this happens and other times it does not.

If I open up another instance of SQL Server Management Studio, we are running SQL Server Management Studio v18.12.1, and I attempt to <Right-Click> on a SQL Server Entity to get its Script, the second instance of SQL Server Management Studio will just spin and then eventually shut down and pop-up a message box indicating SSMS 18 has Stopped Working. If I look further into the dialogue window pane it states...

An unhandled Microsoft .NET Framework exception occurred in [31452] Ssms.exe

Now I did do a little searching on this and saw that this may be a RAM issue??

We are also running Red Gate's SQL Server Management Studio Suite of Tools as well. Soooo not sure if that has anything to do with this or not.

Can anyone confirm what is happening here and provide a solution?

Do I need to ask for more RAM? And what is recommended and how would I check?

This is a major pain in the butt as if I need to <Right-Click> on an entity I can only seem to do it in the initial instance of SQL Server Management Studio that I have opened up.

Thanks in advance for your review and am hopeful for a reply.

SQL Server | Other
{count} votes

2 answers

Sort by: Most helpful
  1. Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator
    2022-12-02T22:28:49.753+00:00

    Unless it explicitly says "out of memory", I would not expect RAM to be an issue. How much RAM do you have?

    As for why it is keeps crashing, I don't know. I rarely see SSMS dying myself, but SSMS is a versatile tool, so you and I may not be using SSMS in the same way. That is, you may be hitting a bug in some corner of SSMS that I don't touch myself.

    I don't want to point fingers as Red Gate, but that is certainly a suspect.

    You could try SSMS 19 Preview 3 and see if that works better. Note that installing SSMS 19 will not affect your current installation, but you can run SSMS 18 and SSMS 19 in parallel.

    0 comments No comments

  2. YufeiShao-msft 7,146 Reputation points
    2022-12-05T08:11:15.68+00:00

    Hi @Bobby P

    This may be cause by Microsoft .NET Framework issue, please try to download Microsoft .NET Framework Repair Tool to repair it

    -------------

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.