Converting ntext to nvcharmax(max) - Getting around size limitation

sql nvarchar

That is most likely because the column dataNVarChar is not defined as NVARCHAR(max)To convert a column from NTEXT to NVARCHAR(MAX), use this

alter table TBL alter column COL nvarchar(max)

It will perform the conversion of the data in the column for you at the same time

CodeHunter