error : 'QUOTED_IDENTIFIER, ARITHABORT'

I have an error like this :
[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'.
Can anyone explain to me ? what does it means ?
How to setting 'QUOTED_IDENTIFIER, ARITHABORT'
ThanksI assume this is from a maint plan job?
You have computed columns or views with indexes on them, and you are trying to reorganize the data.
Unfortunately the main wiz doesn't execute the correct SET command for its connection, meaning that
it can't rebuild using DBCC DBREINDEX. You can create a TSQL job yourself from where you specify the
appropriate SET commands and then execute DBCC DBREINDEx (or DBCC INDEXDEFRAG).
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Kresna Rudy K" <kresnark@.yahoo.com> wrote in message
news:1ad0401c387e3$55b5a740$a601280a@.phx.gbl...
> I have an error like this :
> [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'.
> Can anyone explain to me ? what does it means ?
> How to setting 'QUOTED_IDENTIFIER, ARITHABORT'
> Thanks|||It's true , this error came from maintainence plan job,
but I still don't understand because I don't use view or
computed column with indexes, I use standart version of
sql 2000, this version doesnot support index view.
Please explain to me,
Thx Tibor.
>--Original Message--
>I assume this is from a maint plan job?
>You have computed columns or views with indexes on them,
and you are trying to reorganize the data.
>Unfortunately the main wiz doesn't execute the correct
SET command for its connection, meaning that
>it can't rebuild using DBCC DBREINDEX. You can create a
TSQL job yourself from where you specify the
>appropriate SET commands and then execute DBCC DBREINDEx
(or DBCC INDEXDEFRAG).
>--
>Tibor Karaszi, SQL Server MVP
>Archive at: http://groups.google.com/groups?oi=djq&as
ugroup=microsoft.public.sqlserver
>
>"Kresna Rudy K" <kresnark@.yahoo.com> wrote in message
>news:1ad0401c387e3$55b5a740$a601280a@.phx.gbl...
>> I have an error like this :
>> [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'.
>> Can anyone explain to me ? what does it means ?
>> How to setting 'QUOTED_IDENTIFIER, ARITHABORT'
>> Thanks
>
>.
>|||Nothing stop you from creating an index on a computed column or a view in standard edition. Try and
you will see:
USE pubs
GO
CREATE view v with schemabinding
as select au_id, au_lname from dbo.authors
GO
create unique clustered index ix on v(au_id)
You can try below to see if you have indexes in view. Run in each database:
select * from sysobjects where type = 'V'
and objectproperty(id, 'IsIndexed') = 1
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"kresna rudy k" <kresnark@.yahoo.com> wrote in message
news:1aeb201c387f2$0aed5ff0$a601280a@.phx.gbl...
> It's true , this error came from maintainence plan job,
> but I still don't understand because I don't use view or
> computed column with indexes, I use standart version of
> sql 2000, this version doesnot support index view.
> Please explain to me,
> Thx Tibor.
>
> >--Original Message--
> >I assume this is from a maint plan job?
> >
> >You have computed columns or views with indexes on them,
> and you are trying to reorganize the data.
> >Unfortunately the main wiz doesn't execute the correct
> SET command for its connection, meaning that
> >it can't rebuild using DBCC DBREINDEX. You can create a
> TSQL job yourself from where you specify the
> >appropriate SET commands and then execute DBCC DBREINDEx
> (or DBCC INDEXDEFRAG).
> >
> >--
> >Tibor Karaszi, SQL Server MVP
> >Archive at: http://groups.google.com/groups?oi=djq&as
> ugroup=microsoft.public.sqlserver
> >
> >
> >"Kresna Rudy K" <kresnark@.yahoo.com> wrote in message
> >news:1ad0401c387e3$55b5a740$a601280a@.phx.gbl...
> >> I have an error like this :
> >>
> >> [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'.
> >>
> >> Can anyone explain to me ? what does it means ?
> >>
> >> How to setting 'QUOTED_IDENTIFIER, ARITHABORT'
> >>
> >> Thanks
> >
> >
> >.
> >