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.

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.