We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

String or binary data would be truncated - Determining Which Field ?

Medium Priority
640 Views
Last Modified: 2012-06-21
During the import of a table with about 80 columns and 1 million rows, I've received the error that "String or binary data would be truncated" ... however, SQL 2005 doesn't tell you which column is being truncated.  

Is there any way to determine this, perhaps more robust error message options, etc.?  A setting somewhere in SQL that will give more details?  Or an error log I'm not aware of that would tell me more information?

I know how to fix the error itself ... my question is about getting more information out of SQL as to what the exact error was.

Thanks


Comment
Watch Question

Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
I guess there is not short and sweet way of doing so other than just checkout all string column with it's size and comparing it with the data your inserting or updating.
Jagdish DevakuSr DB Architect
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
I guess nothing can show you which column is culprit.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.