Post reply

Optimization and Integrity Check Jobs failing

  • June 23, 2008 at 6:42 am

    #381290

    Optimization and Integrity Check Jobs failing..This is what I got from error files.

    DBCC failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'.

    Any solution?

    Thanks in Advance.

    --

  • June 23, 2008 at 7:00 am

    #832622

    Check this out:

    http://support.microsoft.com/kb/301292

    Maninder
    www.dbanation.com

  • June 23, 2008 at 7:02 am

    #832626

    I've had this happen, it can be fixed. Sad to say I just don't remember exactly what I did to fix it, was quite a while ago.

    I think this came up when I added calculated columns or indexed views to tables in an existing DB. Never had this error before that, but after the change went in the error happened consistently.

    Anyway, I believe you should be able to debug this in a query window. Copy the parameters from the failing maint plan job, and run in query window using xp_sqlmaint. Maybe all you need to do is add the two requested SET stmts above the xp_sqlmaint call. If that works I think you'll have to semi-abandon the maint plan approach & write your own job step.

  • June 23, 2008 at 9:58 am

    #832845

    Please read this and you should be ready..

    http://support.microsoft.com/kb/902388

    Manoj

    MCP, MCTS (GDBA/EDA)

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply