Some rows giving "String or binary data would be truncated" error when editing in Management Studio

I've experienced this on occasions when a table had a mixture of ntext and nvarchar(MAX) datatypes. Changing all the ntexts to nvarchar(MAX)s fixes the problem.


This error typically occurs when you exceed the length of the data type for the column. Are you inserting more than 150 characters into the column?