Error with nvarchar(max) and text fields

Automate and integrate using the SQL comparison API

Error with nvarchar(max) and text fields

Postby » Fri Nov 15, 2013 9:56 pm

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



Cannot convert data type nvarchar(max) to text.
Posts: 6
Joined: Thu Mar 11, 2010 4:28 pm

Postby Brian Donahue » Mon Nov 18, 2013 3:42 pm

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).
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Target is SQL Server 2008 R2

Postby » Mon Nov 18, 2013 3:58 pm

The target db for this comparison is sql server 2008 r2
Posts: 6
Joined: Thu Mar 11, 2010 4:28 pm

Return to SQL Comparison SDK Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests