SQL Server 2000

pts.
Tags:
SQL
SQL Server
Receiving this error: Microosoft OLE DB Provider for SQL Server error '80040E57' string or binary data would be truncated. I know this error is caused by trying to insert too many characters into a definded column. How can I correct this error. Thanks Alice Morgan

Answer Wiki

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

What you need to do, is usually to either expand the limits of the datatype. I.e. varchar(100) to varchar(200), og you must make sure, that the values given to the column does not exceed the maximum number of characters for the data-definition for your column!

Jacob

Discuss This Question: 1  Reply

 
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
  • DaveInAZ
    Another possibility is that it's not SQL Server that can't handle the data, it's the OLE DB Provider. If you're dealing with a Text column or an Image column in SQL Server, it's unlikely your data exceeds their limits. If that's the case, go to the MS KB (http://support.microsoft.com/search/?adv=1) and search for "getchunk", then pick the article that deals with the language you're working with. Or, do a search with "getchunk" and the name of the language, to narrow it down.
    0 pointsBadges:
    report

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