I was delivering a SQL Server upgrade class last week in Toronto Canada. I got asked a slightly off topic question. It went something like this…
“Can you get the text in management studio to word-wrap?”
Word-wrap is not on by default. You can see from the image below we have scroll bar which we need to use to read the full line
It’s a small thing, but I had never looked for this option before. Not knowing the answer I went straight to my demo machine and started looking at the SSMS options
Tools > Options > expanded the Text Edit
You can see there is an option for word wrap in management studio. If you choose Word wrap and the sub-option to show a glyph when the text has wrapped you get word wrap
It helps makes your code easier to read too and removes the need for a scroll bar.