>>I don't think you can do that in SSMS.
>
>How one can proceed to see such a field?

In the past I used VFP remote views to access/modify text columns. I don't have to deal with text columns lately.
You may also look for third part tools, like Apexsql Edit, that allows to view text colums.