• This is a good idea for QOD, unfortunately the QOD itself was ruined by a syntax error. The REPAIR_FAST argument cannot be used without a database name or ID.

    http://msdn.microsoft.com/en-us/library/ms176064.aspx

    DBCC CHECKDB (Transact-SQL)

    Syntax


    DBCC CHECKDB

    [

    [ ( database_name | database_id | 0

    [ , NOINDEX

    | , { REPAIR_ALLOW_DATA_LOSS | REPAIR_FAST | REPAIR_REBUILD } ]

    ) ]

    [ WITH

    {

    [ ALL_ERRORMSGS ]

    ...

    }

    ]

    ]

    When you try to run the command "DBCC CHECKDB , REPAIR_FAST", you get the following error: "Msg 102, Level 15, State 1, Line 1. Incorrect syntax near ','."

    The correct syntax is something like "DBCC CHECKDB (AdventureWorks, REPAIR_FAST)" or "DBCC CHECKDB (5, REPAIR_FAST)".

    And the correct answer to the QOD is "returns an error message - you have to specify a database".