none
Receiving error when running sp_blitz RRS feed

  • Question

  • Msg 1934, Level 16, State 1, Procedure sp_Blitz, Line 3672 [Batch Start Line 5]
    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.

    I have tried to run it like such:

    USE Master

    SET QUOTED_IDENTIFIER OFF
    GO
    SET ANSI_PADDING ON
    GO
    exec sp_Blitz
    go

    And like such:

    SET QUOTED_IDENTIFIER ON
    GO
    SET ANSI_PADDING ON
    GO
    exec sp_Blitz
    go

    Neither works.  What should the Quoted Identifier be set to?


    AS

    Friday, February 14, 2020 5:39 PM