I have a SQL Server 2012 linked table that has a nvarchar(max) SQL field.
When I open the table and look at the data I can see all the data but the data in the nvarchar(max) field. The nvarchar(max) field just says OLE object not the actual data within this field. BTW the test data is only 20 - 50 bytes not the multi K data that will be going in there during production.
How can I get access to show this data?