• GilaMonster (6/5/2010)


    Please run the following and post the full and complete output:

    DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

    What's the exact version of SQL that you're running?

    SELECT @@Version

    Pls find the output of the command.

    Server: Msg 2511, Level 16, State 2, Line 1

    Table error: Object ID 2105058535, Index ID 0. Keys out of order on page (1:2528), slots 0 and 1.

    Server: Msg 2511, Level 16, State 1, Line 1

    Table error: Object ID 2105058535, Index ID 4. Keys out of order on page (1:140360), slots 37 and 38.

    Server: Msg 2511, Level 16, State 1, Line 1

    Table error: Object ID 2105058535, Index ID 4. Keys out of order on page (1:140360), slots 39 and 40.

    CHECKDB found 0 allocation errors and 3 consistency errors in table 'Mytable' (object ID 2105058535).

    CHECKDB found 0 allocation errors and 3 consistency errors in database 'SERVer'.

    repair_rebuild is the minimum repair level for the errors found by DBCC CHECKDB (SERVer).

    Version Details:

    Microsoft SQL Server 2000 - 8.00.2055 (Intel X86)

    Dec 16 2008 19:46:53

    Copyright (c) 1988-2003 Microsoft Corporation

    Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)