Why this error when inserting to text type field

• mw_sql_developer

  SSCoach

  Points: 19445

  More actions

  March 8, 2015 at 2:15 pm

  #295847

  See attached image...

  The columns are of type text

  I made this insert stmt using a stored proc...

  I mean the [text] field values from another table is converted to varchar(max) and then to VARBINARY(max) and then to HEX value.

  Why this error only when I try to insert to this particular column [[Conclusions]] ?

  Other columns ( of type text ) did not have this issue

• TomThomson

  SSC Guru

  Points: 104768

  More actions

  March 8, 2015 at 4:59 pm

  #1782409

  This is a duplicate of your post http://www.sqlservercentral.com/Forums/FindPost1666510.aspx'.

  The answer is in that thread.

  Tom