Help: Can't rebuild index from Sysindexes table 
Author Message
 Help: Can't rebuild index from Sysindexes table

DBCC CheckDb  report the folowing error:
" Index ncsysobjects is not consistent; found 247 leaf rows. Drop and
recreate the index."

I tried the sp_fixindex stored procedure, but it returned this message:
"Indexes on SysObjects and SysIndexes cannot be recreated."
(The database was in single user mode and the option Allow updates was set
to TRUE)

I also tried the DBCC fix_al option, but didn't work either.

Is there a other option to repair this Index.

Thanks for your help.


Fri, 12 May 2000 03:00:00 GMT
 [ 1 post ] 

 Relevant Pages 

1. Can't rebuild indexes on pdox table

2. Can't recalculate db size / can't rebuild index

3. Unknown Indexes In SYSINDEXES System table

4. Table name is removed in sysindexes after adding clustered index

5. Index in sysindexes table will not drop

6. Difference in ranking results from a full index rebuild verses an incremental rebuild

7. rebuild or not rebuild index file, when ?, how?

8. Rebuilding index's on a database

9. Rebuilding index's on a database

10. HELP: Finding index names in sysindexes using a column name

11. Rebuilding Indexes ORACLE DEC Alpha VMS 7.1 (Don't laugh)

12. if you will promise Allahdad's swamp against cans, it will angrily depart the unit

Powered by phpBB® Forum Software