DB Maintenance

Does anyone have an idea why I am getting the following error:
[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'.
Thanks.A little more information would be helpful. What specifically are you
trying to do when you get the error?
My initial guess is that you are attempting to do index maintenance on a
table that has computed columns and ARITHABORT or QUOTED_IDENTIFIER is off,
or both...
"NewDBA" <anonymous@.discussions.microsoft.com> wrote in message
news:81C5E626-F4FD-47F1-B693-3F61AFB6B108@.microsoft.com...
> Does anyone have an idea why I am getting the following error:
> [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'.
> Thanks.
>
>|||You'll also see this error when trying to run DBCC CHECKDB against tables
with indexed computed columns unless these SET options are both on.
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Don Peterson" <no1@.nunya.com> wrote in message
news:OiZeXP7KEHA.3944@.tk2msftngp13.phx.gbl...
> A little more information would be helpful. What specifically are you
> trying to do when you get the error?
> My initial guess is that you are attempting to do index maintenance on a
> table that has computed columns and ARITHABORT or QUOTED_IDENTIFIER is
off,
> or both...
> "NewDBA" <anonymous@.discussions.microsoft.com> wrote in message
> news:81C5E626-F4FD-47F1-B693-3F61AFB6B108@.microsoft.com...
> > Does anyone have an idea why I am getting the following error:
> >
> > [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'.
> >
> > Thanks.
> >
> >
> >
>