sql server - String or Binary DAta would be truncated on Delete -


I'm trying to delete some lines

USING

SQL Server Management Studio, only gets me the message for 2 rows

No row was deleted

  There was a problem trying to delete line #x Error Source: .NET SqlClient Data Provider Error Message: String or binary data will be deducted Statements have been terminated Fix errors and then Try removing the line or change press Esc to cancel  

What is maybe the line to be deleted?

The keys are unique, so there is no issue

I have removed the rows using the manual DELIE statements but curious about what is happening here

Any thoughts?

This is using SQL 2008 R2 Express Edition

Update - There are no triggers on the table

If you try to run a SQL Profiler while deleting via SSMS, then you want to know how this is true,

Do you have the trigger removed on the table? It is possible that you are more likely to pass through a GUI rather than one of the variables entering an audit table instead of a query window.

In any case, providing table definitions and rows can help others find a solution to your question removed.


Comments