At times, when opening a new query window, or selecting top 1000 rows, Microsoft SQL Server 2012 Management Studio would crash with the following error message “SQL Server Management Studio has stopped working“:
When I click on the “View problem details” link, we can get a few unhelpful details about “CLR20r3“, “ssms.exe“, “Microsoft.VisualStudio.Platform.VSEditor” and “System.NullReferenceException“, thank you very much.
After much googling with Bing, all solutions pointed to restarting the machine. Well, I wanted to avoid that, as my server is in production.
I thought, well, let’s be smart and delete a few folders in my %AppData% directory. It can’t get worse and might solve the issue.
It did get worse. I couldn’t even start Management Studio anymore, and a friendly error message “The directory name is invalid” mentioning “mscorlib” as the source of the problem.
I deleted the whole local profile, it solved the “mscorlib” issue. But my original “CLR20r3” was still there.
And then my eyes wandered in the bottom right corner of the screen, and noticed a weird asterisk (starlike symbol) in the language preferences tray:
Mmm, let’s switch that to “ENG“. Start SQL Server Management Studio again and … tada! It works! Problem solved!
Wonderful. No idea where this asterisk comes from, and why the editor crashes because of that.
I hope this will help someone out there.