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)