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

Question

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.

Answer 1

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