Effect of ANSI_WARNINGS Setting The ANSI_WARNINGS setting affects query processor behavior regardless of the current settings of ARITHABORT and ARITHIGNORE. For example, if SET ARITHABORT or SET ARITHIGNORE is set to OFF and SET ANSI_WARNINGS is set to ON, Microsoft SQL Server 2005 will still return an error message when it encounters divide-by-zero or overflow errors.