SQL Server: SSMS – Hung Symptoms – Mouse-clicks Don’t Register Due To Hidden Modal Window Behind SSMS

I am not sure if run into this but I do often enough on my SSMS 17.9.1 version – suddenly, the SSMS window will not register any mouse-clicks although it will seemingly look fine. The reason is because there is a Modal Window somewhere hidden. Sometimes, ALT-TAB followed by ESC will do the trick but not always.  In the beginning, when I did not know about the modal window, I used to kill SSMS and restart it but you don’t have to.

The hidden Modal window will have something like this:

Actual_Error.jpg

Now, the question is how do you close this if you can’t see it?

Open “Task Manager”, look for SSMS and then among the multiple options, choose the “message window” from above

Task_Manager.jpgRight-click and switch to it

Task_Manager_Switch_To

..and close it!

This problem is annoying enough that knowing this solution may help you not lose your open work!

Advertisements

One thought on “SQL Server: SSMS – Hung Symptoms – Mouse-clicks Don’t Register Due To Hidden Modal Window Behind SSMS

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s