Dbcc Checkdb

Hi,

I don't succeed to do a "dbcc checkdb (BASE)".

I use SQL SERVER 8.00.760 (SP3)

1) Server properties :
NONE default connection option is set

2) Database MASTER and others :
The property "Quoted Identifiers" is NOT set

The result of "dbcc checkdb (BASE)" is always the same :
Error message 1934 "DBCC failed because the following SET options have incorrect settings : 'ANSI_NULLS., QUOTED_IDENTIFIER, ARITHABORT'.

and that, either in Query Analyze or via OSQL command.

Even what is shown in article Q301292 of Microsoft doesn't works correctly ...

Thanks a lot for anyone who could help me to succeed.Can you post your set options - also, does this happen with checkdb ?|||1) OSQL - SET OPTIONS ==> See file "OSQL_DBCC_..."

dbcc checkdb (BASE) is correctly working if I enter previously

set quoted_identifier on
go
set arithabort on
go

2) QUERY ANALYZER - SET OPTIONS :

Set Option Value
----------- --------------
textsize 64512
language Franais
dateformat dmy
datefirst 1
quoted_identifier SET
arithabort SET
ansi_null_dflt_on SET
ansi_defaults SET
ansi_warnings SET
ansi_padding SET
ansi_nulls SET
concat_null_yields_null SET

(12 ligne(s) affecte(s))

dbcc checkdb (BASE) is correctly working WITHOUT any change

So, which is the best way in order "dbcc checkdb" runs OK in either case ?|||So are you saying that it is functioning properly now ? Did you make any modifications using sp_dboption ?