R
Ruben Dröge
Guest
Can you try to edit the statement and cast the NTEXT field as a NVARCHAR : CAST (nTextColumn AS NVARCHAR(MAX)) So that would result in something like this (untested, so please make sure you've backed up everything 
: INSERT INTO RB_TRANSLATION (CUST_ID,LANGUAGE,GLOBAL_ID,FIELD_NAME,TEXT_VALUE) SELECT DISTINCT CUST_ID,LANGUAGE,GLOBAL_ID,FIELD_NAME,CAST(TEXT_VALUE AS NVARCHAR(MAX)) FROM RB_TRANSLATION_BACKUP GROUP BY CUST_ID,LANGUAGE,GLOBAL_ID,FIELD_NAME;
Continue reading...
: INSERT INTO RB_TRANSLATION (CUST_ID,LANGUAGE,GLOBAL_ID,FIELD_NAME,TEXT_VALUE) SELECT DISTINCT CUST_ID,LANGUAGE,GLOBAL_ID,FIELD_NAME,CAST(TEXT_VALUE AS NVARCHAR(MAX)) FROM RB_TRANSLATION_BACKUP GROUP BY CUST_ID,LANGUAGE,GLOBAL_ID,FIELD_NAME;Continue reading...