>Hi,
>
>When my program executes a stored procedure that updates many fields, the following error is generated:
>
>
>String or binary data would be truncated.
>
>
>I know that it means that I am trying to set the value greater than the column type/length allows.
>
>Is it possible to have the error to include which column is the problem?
Never! That is against Microsoft's policy!
Or else they have fixed the "file not found" which never tells you which file was it. It's unchanged since 1981 or thereabouts. This immediate amnesia, where the code immediately forgets which file/field/routine caused the error, is a long standing feature which will live longer than we do.