I'm trying to delete a couple of rows


SQL Server management studio, for 2 rows only i get the message

No rows were deleted

Error message
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)

Recommended Answers

All 3 Replies

That means you are trying to insert more data into a column than it can hold. Check your input against the column size. SQL Server does not truncate, but raises an exception.

Dear pritaeas
My data already inserted in table.

I'm trying to delete a couple of rows
Then it gives a error msg..

Is there perhaps a trigger doing some additional processing which is causing the error?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.