Can’t manually enter data any more; get Error Message: String or binary data would be truncated.

5 pts.
Tags:
Binary data
SQL Server 2005
SQL Server 2005 SP2
SQL Server errors
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
ASKED: December 5, 2008  6:23 PM
UPDATED: December 6, 2008  1:33 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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?

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following