When I Use this Options : @get_task_info = 2 Getting failed.

amachanic / sp_whoisactive

sp_whoisactive

GNU General Public License v3.0

1.17k stars 289 forks source link

When I Use this Options : @get_task_info = 2 Getting failed. #37

Closed mdurajesh-rk closed 3 years ago

mdurajesh-rk commented 3 years ago

Msg 1934, Level 16, State 1, Line 463 SELECT 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.

amachanic commented 3 years ago

Sounds like you need to re-create the stored procedure. I think there are SET settings at the top of the script?

erikdarlingdata commented 3 years ago

@mdurajesh-rk haven't heard back from you in a while on this, so I'm gonna close it out for now. If you're still running into the issue, provide from more detail and we'll re-open it.