Error with nvarchar(max) and text fields

dbouchard@tricomputer.com

when I compare 2 databases with text fields, I get an error as follows on the below command from the diff script:

EXEC(N'DECLARE @pv binary(16)
'+N'SELECT @pv=TEXTPTR([notes_log]) FROM [cqadmin].[Defect] WHERE [dbid]=33731958
UPDATETEXT [cqadmin].[Defect].[notes_log] @pv NULL NULL N''
===== State: Review by:lvl7build at 09/11/2013 08:35:25 =====
Coverity resolved this issue based on label: FMZ20130911_1

...')

Error:

Cannot convert data type nvarchar(max) to text.

Brian Donahue

Just to make sure, the destination is not SQL 2000, is it? SQL 2000 did not support nvarchar(MAX) so there is probably no implicit conversion for that. This would probably include databases that are in SQL 2000 compatibility mode (compat mode 80).

dbouchard@tricomputer.com

The target db for this comparison is sql server 2008 r2