' In SQL Server, we have to turn off ANSI Warnings as we will have an error ' if a field value is greater than the field length If nBackend = 2 Then oCommand.CommandText = "SET ANSI_WARNINGS OFF; " + oCommand.CommandText End IfHowever, this is effective for all updates or inserts in a hit. If anyone would have a simpler method where the setting would only be set once per hit, that would be great.