SQL Server 2012 SSMS – How to View Special Characters in Management Studio Grid View

sql-server-2012ssms

In a SQL Server 2012 database, I have a log table where I log SQL queries executed by a VB.NET application.

The field is defined as nvarchar(MAX)

In Microsoft SQL Server Management Studio, when I go to the table and do "Edit All Rows",
on one line I see spaces in the end of the text ScreenShot 1

But when I enter my cursor in the line to edit it (not touching anything, before I even start editing), the spaces disappear (along with the trailing quote) Screenshot 2

And when I go to New Query and execute the same query 

SELECT LOGID, LogDate, SqlLog 
FROM ezber_SQL_LOG 
WHERE (LOGID = 1604))

I get the result without the spaces and the trailing quote:

Screenshot 3

So my guess is that there are special characters in the data (line breaks, tabs or something like that), but how can I find out for sure and know what they are?

Best Answer

Have a look at the answer in following post: (the one with pictures).

https://stackoverflow.com/questions/11897950/how-do-you-view-all-text-from-an-ntext-or-nvarcharmax-in-ssms/11900246#11900246

You need "copy current cell 1:1", or you can use notepad++ as visualizer:

Related Question