Dbcc checktable wrong, how to do the next step? FYI : .... .... Keys of index table for id 9 'n_cust' in index page not in correct order. Drop And re-create the index. (Index page 11270) Msg 2511, Level 16, State 2 : Server 'DSZX' Line 1 : Keys of index table for id 9 'n_cust' in index page not in correct order. Drop And re-create the index. (Index page 11270) Msg 2511, Level 16, State 2 : Server 'DSZX' Line 1 : Keys of index table for id 9 'n_cust' in index page not in correct order. Drop And re-create the index. (Index page 11270) Msg 2511, Level 16, State 2 : Server 'DSZX' Line 1 : Keys of index table for id 9 'n_cust' in index page not in correct order. Drop And re-create the index. (Index page 11270) Msg 2511, Level 16, State 2 : Server 'DSZX' Line 1 : Keys of index table for id 9 'n_cust' in index page not in correct order. Drop And re-create the index. (Index page 11270) Msg 7931, Level 16, State 1 : Server 'DSZX' Line 1 : [color=Red]Table Corrupt : keys in right child precede the parent key; check right child Page 10190.[/color] Msg 7930, Level 16, State 1 : Server 'DSZX' Line 1 : Table Corrupt : keys in left child do not precede the parent left key; check Child page ICC. DBCC execution completed. If DBCC printed error messages, contact with a user System Administrator (SA) role. Thanks Got the following from TS guide for you : Explanation This serious error is returned by dbcc checktable or dbcc checkdb (which calls dbcc checktable). Dbcc checktable checks a table and its indexes to determine whether : Pages are linked correctly Indexes are properly sorted Pointers are consistent Page offsets are consistent Sysindexes pages are correct The data row count is equal to the leaf row count for nonclustered indexes During index level checking, for each key in the parent page. dbcc checktable checks whether the last key in the left page is less than the parent key child. and whether the first key in the right child page is greater than or equal to the parent key. If the last key in the left child is not less than the parent key. Error 7930 occurs. Action Use the procedure in "How to Find an Object Name from a Page Number" in the Encyclopedia of Tasks chapter to identify which correspond to the page table and index number from the error message text. If the object encountering the error is not a system table (a table system 's object ID is less than 100), continue with step 3. If the object with the error is a system table and the index ID is not zero. refer to "How to Fix a Corrupted Index on System Tables" in the Encyclopedia of Tasks chapter for instructions on how to repair the system table index. Then go to step 5. If the object with the error ID is a system table and the index is 0. contact Sybase Technical Support. They may be able to help you repair the corruption but it may be necessary to clean and restore from backups. If the object with the error table and the index is a user ID is not 0, determine whether there is a clustered index on the table : 1.In sp_helpindex table_name Ver.2 go Where table_name is the name you determined in step 1. If there is a clustered index on the table, rebuild it. Then go to step 5. If there is a nonclustered index on the table, rebuild the index using the following steps. Translate the index ID into an index name : 1.In use database_name Ver.2 go 1.In select name from sysindexes Ver.2 where id = object_ID index_ID3> go and indid = To ensure that the information needed to re-create the index is available, run sp_helpindex on the index prior to dropping it. Drop the index. Re-create the index. This clears the corruption in most cases. Run dbcc checktable on the table to verify that the corruption is gone. If corruption still exists, call Sybase Technical Support. Is to rebuild index 1,10? [ Closed window ]