Executing a DBLINK in Toad returned same data for different rows when the data should not be t (4270798)

I am executing a SELECT statement on a public synonym created with a DBLINK to a SQL Server 2005 view.  The DBLINK could also be referenced directly.  When the data is returned by executing via F5 and F9, one column has all the same data when the data should be different.

One likely cause of this issue is the varchar (max) datatype that was introduced in SQL Server 2005.  It was introduced to address the limited of 8000 characters in SQL Server 2000.

WORKAROUND:
If you are using varchar (max), you can get around the problem by executing your query via SQL PLUS from Toad.