title: String or Binary DAta would be truncated on Delete
body: <p>I'm trying to delete a couple of rows </p>
  
  <p>USING</p>
  
  <p>SQL Server management studio, for 2 rows only i get the message</p>
  
  <p>No rows were deleted</p>
  
  <pre><code>A problem occurred attempting to delete row #X
  Error Source: .Net SqlClient Data Provider
  Error Message: String or binary data would be truncated
  The Statement has been terminated
  
  
  Correct the errors and attempt to delete the row again or press ESC to cancel the change(s)
  </code></pre>
  
  <p>What could be happening while deleting the row ?</p>
  
  <p>the keys are unique so that's not an issue</p>
  
  <p>I've deleted the rows using manual DELETE statements but curious about what's going on here</p>
  
  <p>any thoughts ?</p>
  
  <p>this is using SQL 2008 R2 Express edition</p>
  
  <p>UPDATE  - there are no triggers on the table</p>