Red Gate forums :: View topic - Error with nvarchar(max) and text fields
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Comparison SDK 10
SQL Comparison SDK 10 forum

Error with nvarchar(max) and text fields

Search in SQL Comparison SDK 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
dbouchard@tricomputer.com



Joined: 11 Mar 2010
Posts: 6

PostPosted: Fri Nov 15, 2013 10:56 pm    Post subject: Error with nvarchar(max) and text fields Reply with quote

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.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6649

PostPosted: Mon Nov 18, 2013 4:42 pm    Post subject: Reply with quote

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).
Back to top
View user's profile Send private message
dbouchard@tricomputer.com



Joined: 11 Mar 2010
Posts: 6

PostPosted: Mon Nov 18, 2013 4:58 pm    Post subject: Target is SQL Server 2008 R2 Reply with quote

The target db for this comparison is sql server 2008 r2
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group