Whats the most annoying error message?
Very very high up on my list has to be "String or binary
data would be truncated." Error 8152.
Why is this annoying? Because you have no idea which column it is referring
to.
On recently encountering this again I looked to see if anyone had asked for a
niceer message on connect. Low and behold they had http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125347
It currently only has a few votes, but it does have a response saying that
this will be improved in the next release after Yukon. Well I guess that means
Katmai.
I've tested it on CTP5 and I still get the same error so I just hope its
coming in CTP6.
If you want to make sure its changed get voting. http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125347
-