>SQL Server is very smart. If we pass a string that is too long for a field, in a SQL insert command for example, it will generate an error "String or binary data would be truncated." Is there a setting that controls that? I will adjust the code for that but I was wondering if there was something that could be a factor here.

See SET ANSI_WARNINGS