Post reply

Optimizations job error message

  • March 1, 2006 at 11:59 am

    #152794

    Good morning all!  Another issue I need help with!

    I have a maintenance job that has run fine for what seems forever.  Today the optimizations section failed.  This is the error message that I got out of the report:

    [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'.

    Why did it fail now??  How do I fix it??

    Thanks in advance everyone!!

    Thank you!!,

    Angelindiego

  • March 1, 2006 at 12:46 pm

    #624108

    Check into Set ArithAbort.

  • March 1, 2006 at 3:23 pm

    #624150

    Thanks Kory...headed there now!

    Thank you!!,

    Angelindiego

  • March 2, 2006 at 12:50 am

    #624206

    check these articles:

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

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

    hope this helps

  • March 2, 2006 at 9:21 am

    #624348

    Thank you Martin...off to read!!

    Thank you!!,

    Angelindiego

  • March 2, 2006 at 10:28 am

    #624390

    ok, I read all of this stuff.  This is indeed my issue.  SP4 is not an option at this point, so the first read won't work.  If I run the reindex script have the sets at the top it works.  No issues.  But the job itself still fails.  Is there a way, without having sp4 installed, that I can set these options and have it run without error????????????????????????

    Thank you!! 

    Thank you!!,

    Angelindiego

Viewing 6 posts - 1 through 5 (of 5 total)

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