Q:

SQL Server Management Studio show complete content of field varchar(max)

There is a way in SQL Server Management Studio to read all the contents of a varchar(max) column when you run a select? 
I know that there is an option in Options > Query Execution > SET TEXTSIZE.  But I was wondering if are something like when you have a XML file that you can click the cell and a new tab is open with the cell contents. 

A:

No - there is no direct way to get full cell data in SSMS grid.  SSMS truncates it. 
But: SSMSBoost add that I develop does what you need: it allows to copy cell contents 1:1.  All bytes, even if there are megabytes ! 
http://www.ssmsboost.com/Features/ssms-add-in-copy-results-grid-cell-contents-line-with-breaks

