Post reply

Detecting DBCC CHECKDB completion status

  • April 30, 2003 at 5:25 am

    #159104

    Is there a way to check whether any errors were reported by a DBCC CHECKDB short of looking at the output?

    If I have to look at the output does the existence of the line:

    "CHECKDB found 0 allocation errors and 0 consistency errors in database 'Test'."

    guarantee there were no errors reported?

    Thanks.

    Phil.

  • May 1, 2003 at 2:00 am

    #455869

    No replies yet!!

    Basically what I am asking is does DBCC CHECKDB return an @@ERROR value <> 0 if it reports errors, or is it necessary to scan the output text for errors.

  • May 1, 2003 at 2:57 am

    #455871

    Yes you can use @@error.

    Zero = no problems.

    Non zero = a problem (usually in the range 8900 - 8999).

    Jeremy

  • May 1, 2003 at 3:03 am

    #455872

    Thanks Jeremy

    Phil.

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

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