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

Published Monday, January 21, 2008 12:04 PM by simonsabin


Saturday, October 30, 2010 12:50 PM by Simons SQL Blog

# Unhelpful error messages

Following my last post on the login failed message not being as helpful as it could be ( http://sqlblogcasts