ide - Is there any way to view whitespace in the query editor for SQL Server Management Studio Express 2005?

Question

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.

question from:https://stackoverflow.com/questions/2760124/is-there-any-way-to-view-whitespace-in-the-query-editor-for-sql-server-managemen

Answer 1

In case you still need to know how to do this.

Edit the Registry Key in HKEY_CURRENT_USER:

SoftwareMicrosoftMicrosoft SQL ServerxxToolsShellText EditorVisible 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:

SoftwareMicrosoftMicrosoftSQL Server Management StudiovText EditorVisible Whitespace

where v in SQL Server 2012 is 11.0 and in SQL Server 2014 is 12.0.