Error with nvarchar(max) and text fields

Automate and integrate using the SQL comparison API

Moderators: Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong

Error with nvarchar(max) and text fields

Postby dbouchard@tricomputer.com » Fri Nov 15, 2013 10: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

...')

Error:

Cannot convert data type nvarchar(max) to text.
dbouchard@tricomputer.com
 
Posts: 6
Joined: Thu Mar 11, 2010 5:28 pm

Postby Brian Donahue » Mon Nov 18, 2013 4: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: 6668
Joined: Mon Aug 23, 2004 10:48 am

Target is SQL Server 2008 R2

Postby dbouchard@tricomputer.com » Mon Nov 18, 2013 4:58 pm

The target db for this comparison is sql server 2008 r2
dbouchard@tricomputer.com
 
Posts: 6
Joined: Thu Mar 11, 2010 5:28 pm


Return to SQL Comparison SDK 10

Who is online

Users browsing this forum: No registered users and 0 guests