Results 1 to 4 of 4

Thread: Dbcc Checkdb

  1. #1
    Join Date
    Sep 2003
    Location
    South of France
    Posts
    11

    Unanswered: 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.
    ALaupenie

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Can you post your set options - also, does this happen with checkdb ?

  3. #3
    Join Date
    Sep 2003
    Location
    South of France
    Posts
    11
    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 Français
    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) affectée(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 ?
    ALaupenie

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    So are you saying that it is functioning properly now ? Did you make any modifications using sp_dboption ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •