I've just switched from SSMS 2008R2 - 10.50.2500.0 to SSMS 2014 - 12.0.2000.8 and I've noticed for my own peculiar "text editor" option settings, that SHIFT + TAB (and the decrease indent icon) take it upon themselves to reformat my code by trying to align the leftmost character of of each line to the nearest tabstop position. This does not happen for what seem to be the same settings in SSMS 2008R2. My settings in both versions are:
Here's an example (before SHIFT-TABBING):
...and after SHIT+TABBING (2014):
...and after SHIFT+TABBING (2008R2)
Does anyone know how I can stop this happening. It's supremely annoying. Oh... and please don't post commentary about the relative aesthetic virtues of the various syntax alignments. That's beside the point. At least I hope it is.
asked Sep 13, 2014 at 04:59 AM in Default
After entering sqlcommunity (SSMS developers) to report the issue, I've found a MS Connect forum and then a SSMS configuration page in MSDN.
The only downside is you will need to adapt to the new 4 chars indentation. I mean, do this: Do new settings, create a new query tab, type any text and press home to go to beginning of line Then type tab several times and instead the usual 8 chr tabs every time... Now you'll see indentation as 4 spaces / 8 chr tab / 4 spaces / 8 chr tab... This is useful, but also a little different than ANY OTHER text editor
Personally, I don't like computer forces me to CHANGE my standard gui behavior, specially after 37 years coding
Anyway, I hope this helps.