I apologize if this is not the correct place to ask this but something is bugging me. I could have swore that at a previous job I could be on the last line of code in SSMS and hit the down arrow and the cursor would move to the end of the line. Now it just stays in the middle of that last line. I'm using SSMS 11.0.2100.60. Is there a setting I'm missing or did I imagine that happening? 🙂
SSMS – Down Arrow on Last Line Issue
ssms
Related Solutions
Try SET STATISTICS XML ON before you run your query. That will return the plan in XML format without trying to render it in SSMS. You could then copy and paste the text into a file. From there, you'll get the plan in XML format, and you can open it up in a tool like SQL Sentry Plan Explorer.
SSMS isn't as full-featured as some other editors out there when it comes to visual formatting. I think the closest you'll get is using word wrap from Tools -> Options and then manually sizing your SSMS window to force it to a smaller column width.
The bottom row of SSMS will tell you what column number your cursor is on, which may be helpful to size your window to approximately 100 columns wide.
Related Question
- Sql-server – How to remove line breaks in SSMS
- SQL Server 2014 – How to Undo Accidental Restore
- Sql-server – SSMS – Is it possible to pass additional connection parameters via Command Line
- SQL Server – SMO and SSMS Slow in Docker on Localhost
- SSMS Keeps Crashing
- SQL Server – Inconsistent Line Breaks in SSMS
- SSMS – Why Dark Theme is Disabled by Default
Best Answer
As already shown in the comments, I've seen/used the same feature in SSMS 2005 as shown here. But I didn't manage to see what ever editor window setting would be different than in SSMS 2012/2014 where the behavior has changed.