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
Post a Comment