Allow SQL Server to Silently Truncate Data February 22, 2018 SQL Server usually presents an error on an attempt to insert more data into a field than it can hold. It typically throws an error message similar to the following: