Advertisement

09.25.2006 at 12:44PM PDT, ID: 22002055
[x]
Attachment Details

String or Binary Data would be truncated

Asked by nathan8 in MS SQL Server

Tags: binary, data, would, string, truncated

In SQL Server, while updating a table using Enterprise Manager, I am getting the following error:
String or Binary Data would be truncated

And the reasong I specified Enterprise Manager above is because the update works perfectly fine using the Query Analyzer.

And I have gone through the site for the mentioned error before posting this question, and the most common reponse I have found is that the data I am entering might be larger than the field's limit. But I have gone through the data and that doesnt seem to be the case.

Please advice if there is any other reason for this error. Start Free Trial
[+][-]09.25.2006 at 12:50PM PDT, ID: 17595688

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]09.25.2006 at 12:57PM PDT, ID: 17595756

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]09.25.2006 at 01:11PM PDT, ID: 17595873

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]09.25.2006 at 01:21PM PDT, ID: 17595966

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]09.26.2006 at 12:19AM PDT, ID: 17599056

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: MS SQL Server
Tags: binary, data, would, string, truncated
Sign Up Now!
Solution Provided By: Hypnochu
Participating Experts: 3
Solution Grade: B
 
 
 
Loading Advertisement...
20080716-EE-VQP-32