title: String or binary data would be truncated.\r\nThe statement has been terminated. while xml insertion
body: <p>Can you please let me know how do I resolve this problem while inserting xml data into Sql Server 2008</p>
  
  <p><code>ex = {"String or binary data would be truncated.\r\nThe statement has been terminated."}</code></p>
  
  <p>I already replaced <code>'</code>, <code>""</code> with an empty string </p>
  
  <p>thanks in Advance</p>