Unanswered: Integrity check and optimization job failed
I found the following error in my maintenance plan please help me on this
Under maintenace plan history i found this error:-
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL Server Driver][SQL Server]UPDATE STATISTICS failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'.
and jobs failed with following error
i found this error in job history of optimization & integrity check jobs:-
Executed as user: XXXX\admin. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.