>When a value is included in a SQL command to be saved on a table, if the length is greater than the field size, we will have the following error:
>
>"String or binary data would be truncated."
>
>Is there a setting in SQL Server to avoid that?

Try SET ANSI_WARNINGS OFF.