The Large Object data types (viz. VARCHAR(MAX), NVARCHAR(MAX), VARBINARY(MAX) and XML) can cater for up to 2GB of data.
The issue may be with the ODBC or OLEDB connections used by the linked server.
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”