Automate and integrate using the SQL comparison API
Moderators: Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong
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 5:28 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).
- Posts: 6668
- Joined: Mon Aug 23, 2004 10:48 am
Return to SQL Comparison SDK 10
Who is online
Users browsing this forum: No registered users and 0 guests