String or binary data would be truncated - by GTrz

Status : 


Sign in
to vote
ID 533212 Comments
Status Active Workarounds
Type Suggestion Repros 0
Opened 2/12/2010 6:18:50 AM
Access Restriction Public


Msg 8152, Level 16, State 13, Line 2
String or binary data would be truncated.
The statement has been terminated.

A lovely error in a 300 lines of SQL update statement in SQL Server 2005, it does not say what field was truncated, what line was truncated.
Sign in to post a comment.
Posted by Microsoft on 8/17/2010 at 8:28 AM
I've closed this as a duplicate of 339410. I'll see what we can do about that one...

Posted by Microsoft on 3/3/2010 at 8:13 AM
Snarky suggestion? Yes.
Valid complaint? Also yes.

I think we should be able to do better here. Thanks for sumbitting this.

Posted by RJ Book on 2/19/2010 at 8:43 AM
I agree with this suggestion, the assumption is the engine knows exectly what column and value would be truncated so if it could be presented back to the User it would be very valuable. Very often I have had to troubleshhot this error and often it is less than obvious what columns to look for.