String or binary data would be truncated MS SQL Error
this error normally occur when you trying to insert value in column which can accommodate value (column size is low)
see the error description of this error is
Quote:This error message appears when you try to insert a string with more characters than the column can maximal accommodate.
and as for solution
Quote:Errors of the Severity Level 16 are generated by the user and are corrigible by the user. The statement cannot be executed this way. You must either shorten the string to be isnerted to widen the column.
