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 ntext
s 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?