Agree with you Japie, although I think there should be a function to override truncation on normal inserts.
If I understand Steve correct, we'd like something similar to SSIS, to choose what happens when truncation should/could occur, along the lines of:
*fictional command below*INSERT WITH NoStopOnTruncate INTO myTable values('string that would be truncated if longer than len')
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle