Results 1 to 4 of 4
  1. #1
    Join Date
    May 2003
    Location
    Atlanta, GA
    Posts
    187

    Angry Unanswered: HELP. DBCC failed.

    Hi all,
    I have a problem and can't find a solution.
    About a week ago, my maintenance program started failing do to a problem with one database it seems.
    I look at my log and I see this error:
    CrystalDB [SQLSTATE 01000]
    Msg 1934, Sev 16: DBCC failed because the following SET options have incorrect settings: 'ANSI_NULLS., QUOTED_IDENTIFIER, ARITHABORT'. [SQLSTATE 42000]

    What does it mean and how can I fix it?

  2. #2
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    What changed?

    -- This is all just a Figment of my Imagination --

  3. #3
    Join Date
    May 2003
    Location
    Atlanta, GA
    Posts
    187
    Thats the thing. Nothing changed on this database.
    I was thinking maybe it has something to do with another database that we have set up for a 3rd party application, and they had us run an upgrade on there application and database, but the error clearly states that the problem is in CrystalDB. Does it not?
    What could have changed for this error to start?
    Can anyone point me in any direction where to start looking?

    Thanks.

  4. #4
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Did someone screw with Crystal in any way, shape, or form? Maybe tried to change a report definition? Messed with an sproc?

    I see the dbcc ... what jobs are running a DBCC? Which dbcc command is running? Have you tried recreating the job / maintenance plan?

    So few clues ... so little information. A week ago?

    -- This is all just a Figment of my Imagination --

Posting Permissions

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