SQL SERVER – Truncating Data and ANSI_WARNINGS


Today’s blog subject of Truncating Data and ANSI_WARNINGS was accidentally discovered while working on the Comprehensive Database Performance Health Check. Let us talk about the topic.

It is very much known that in SQL Server 2019, Microsoft has fixed one of our age-old request about displaying the column which is being truncated while inserting the data. You can read about them in the blog posts here:

SQL SERVER – Identify the column(s) responsible for “String or binary data would be truncated.”SQL SERVER 2019 – Still Getting String or Binary Data Would be Truncated

Let us see the error and message here in this