Member Avatar for Ankur_tces

I'm trying to delete a couple of rows

USING

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)

Edited by pritaeas because: Moved.
  • 2 Contributors
  • 3 Replies
  • 320 Views
  • 1 Hour Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for pritaeas

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.

Member Avatar for Ankur_tces

Dear pritaeas
My data already inserted in table.

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

Member Avatar for pritaeas

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, networking, learning, and sharing knowledge.