SSMS v18 is wonky as hell

Isaac

Lifelong Learner
Local time
Yesterday, 21:05
Joined
Mar 14, 2017
Messages
11,401
Does anybody else agree that if/when you switched to SSMS version 18x, the experience was pretty messed up?

First, my settings were not preserved, although that could be something specific to my company and their install process - and thankfully, I was able to find the residual folder from 17 and import those settings!

Second, and this is the BIG one, double-clicking a .SQL file no longer opens in the existing/already-open instance of SSMS - it ALWAYS opens a new one. So instead of ending up with multiple document tabs in one instance, you end up with a gazillion instances.
Yes, I can drag a .sql file to the window and force it to open in an existing instance, but this is a huge loss from being able to just double click the file!

Third, if all I do is open a blank SSMS with no document/query, you know how the window title generally says Solution1? (even though you have NOT created a query/document window yet). Well, when I close the program under that exact scenario, it persists in asking me "do you want to save changes to solution1?", even though I haven't made any changes or edits and in fact, there isn't even a valid document window open!

I really hope they fix or adjust some of these things soon - it's driving me nuts. I'm sharing the pain because pain shared is pain halved, right?
 
Found this rather intimidating set of instructions, going to try it and report back.

1751392851734.png
 
Well he has been kind enough to give you a reg file.
Though you might need to edit it for your later version?
 
Yeah, I'm trying to work on editing it - registry stuff is not super familiar to me, hopefully I'll be successful.
 
I've just switched over to version 21.3 which is integrated into Visual studio, and is a bit different but I'm liking it, however I'm pretty sure I was on version 19 or 20 before that?

Surprised your not on the latest version?
 
I've just switched over to version 21.3 which is integrated into Visual studio, and is a bit different but I'm liking it, however I'm pretty sure I was on version 19 or 20 before that?

Surprised your not on the latest version?
I guess I misspoke, I am currently on 20.2.37.0 and maybe previously was on 17 or 18, not sure. Either way the new version brought several unnerving aspects to it - refuses to open .sql files on double click and insists on a server connection with every new query window, does not default
 

Users who are viewing this thread

Back
Top Bottom