Ever work with query results that are so long SQL Server Management Studio truncates the results?
sproc results are truncated
I ran into this issue recently while running some utility sprocs that generate C# code for me. I was thinking I’d have to refactor my sprocs, but then I found this helpful setting under Query Options.
Update Max.num characters per column in Query Options > Results > Text
This solved my problem and will hopefully solve yours as well.
- Right click the query editor
- Left click “Query Options…”
- Expand Results in the tree on the left ( in popup dialog )
- Click on Text under Results
- Set “Maximum number of characters displayed in each column” to a number large enough to see all your results.
Quick and easy, hope I remember this setting.
