Blitz procedure failing

by Darrell   Last Updated January 13, 2018 21:06 PM

When I run the latest version of sp_blitz I get the following: Warning: Null value is eliminated by an aggregate or other SET operation.

Msg 1934, Level 16, State 1, Procedure sp_Blitz, Line 3467

INSERT failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. 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.

It seems no one else is having this problem except me. What have I done wrong?



Answers 1


In SSMS settings, make sure the SET QUOTED IDENTIFIER box is checked. That should fix it.

enter image description here

sp_BlitzErik
sp_BlitzErik
July 27, 2016 15:47 PM

Related Questions


Quoting columns with spaces in PostgreSQL?

Updated October 26, 2017 22:06 PM

Strange behaviours with SET options in SSMS

Updated January 13, 2018 21:06 PM


SQL Server Agent: QUOTED_IDENTIFIER

Updated January 13, 2018 21:06 PM

ANSI_NULLS and QUOTED_IDENTIFIERS mismatch

Updated January 13, 2018 22:06 PM