I received the following error while indexing entire
database during optimization time set up by the
Maintenance Plan:
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934:
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed
because the following SET options have incorrect
settings: 'QUOTED_IDENTIFIER, ARITHABORT'
Any suggestions please?
Thanks.
Sang NahmThe maintenance plan has troubles with certain objects such as computed
columns or indexed views. I suggest you create your own scheduled job to do
the reindexing and then you can set those settings as needed.
--
Andrew J. Kelly
SQL Server MVP
"sang.nahm@.ots.treas.gov" <anonymous@.discussions.microsoft.com> wrote in
message news:095e01c3c8b0$97f28ac0$a501280a@.phx.gbl...
> I received the following error while indexing entire
> database during optimization time set up by the
> Maintenance Plan:
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934:
> [Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed
> because the following SET options have incorrect
> settings: 'QUOTED_IDENTIFIER, ARITHABORT'
> Any suggestions please?
> Thanks.
> Sang Nahm
No comments:
Post a Comment