Menu
I have it enabled in Visual Studio 2008, but I'd really like to enable this feature in SQL Server Management Studio 2005 Express. Does anyone know if its possible? Maybe in a later version?
EDIT: Sorry, I meant specifically in the text/query editor.
443
In the Customize Toolbar window, click "Add Command" Click "Edit" in the Categories list. Choose "Toggle Visual Space" in the Commands list. Click "OK"
Use the Activity Monitor. It's the last toolbar in the top bar. It will show you a list of "Recent Expensive Queries". You can double-click them to see the execution plan, etc.
First, like many Windows programs, you can hold down the Control key and use the mouse scroll bar to increase or decrease the font size. Note that as you do that, the percentage of zoom is also displayed in the lower left-hand side of the query window.
In case you still need to know how to do this.
Edit the Registry Key in HKEY_CURRENT_USER:
Software\Microsoft\Microsoft SQL Server\xx\Tools\Shell\Text Editor\Visible Whitespace Where xx is the version you have (90 is 2005, 100 is 2008)
And set it to 1 to show. Or for SQL Server 2012 and up client tools it is also in HKCU:
Software\Microsoft\Microsoft\SQL Server Management Studio\v\Text Editor\Visible Whitespace where v in SQL Server 2012 is 11.0 and in SQL Server 2014 is 12.0.
98
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
