SELECT failed because the following SET options have incorrect settings: ‘ANSI_WARNINGS’

Error:

Msg 50000, Level 16, State 1, Procedure uspXXXXX, Line 581 [Batch Start Line 2]

uspXXXXX | SQL Error 1934 at line 505. SELECT failed because the following SET options have incorrect settings: ‘ANSI_WARNINGS’. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations.

Fix:

Remove the following line from stored procedure…

SET ANSI_WARNINGS OFF;