I've been burnt by this "feature" too often to not recognize it! It took me hours to track down an issue cause by a string truncation that was being passed as a parameter to an SP. Increasing the parameter size was all it took to fix it.

Time spent tracking down the problem: 6.5 hours

Time spent actually fixing the problem: 5 seconds