Can’t manually enter data any more; get Error Message: String or binary data would be truncated.
Three databases that were forced restored now do nor allow manual entry, even one single character, although using an update statement works. This is not a matter of changing the length of the datatype, but something else. For the life of me, I can't figure out why this mere attempt at manual data entry generates the error below:
"No row was updated.
The data is row 2 was not committed.
Error Source: >Net SqlClient Data Provider.
Error Message: String or binary data would be truncated.
The statement has been terminated.
Correct the errors and retry or press ESC to changes the change(s).
Why does this message speak about truncating when only one character is entered?
We are using SQL Server 2005 SP 2
Jim
Software/Hardware used:
Software/Hardware used:
ASKED:
December 5, 2008 6:23 PM
UPDATED:
December 6, 2008 1:33 AM
Answer Wiki:
Could there be a trigger on the table which fires on insert which is causing the problem?
What happens if you try and insert the data using T/SQL instead of the Table editor?
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
