dbcc checkdb

• markwnorsoft

  SSC Eights!

  Points: 827

  More actions

  October 10, 2003 at 3:33 pm

  #358374

  Hi, I'm running sql 2000(sp3) on nt2000(sp3) when I run dbcc checkdb I get this error.

  Server: Msg 602, Level 21, State 16, Line 2

  Could not find row in sysindexes for database ID 6, object ID 555149023, index ID -1. Run DBCC CHECKTABLE on sysindexes.

  Connection Broken

  I ran dbcc checktable on sysindexes. I still get this error. Does anyone have any other ideas?

  thanks

  Mark

• Jonathan

  SSC-Insane

  Points: 20427

  More actions

  October 10, 2003 at 6:56 pm

  #477939

  Put the database in single-user and then run the repair:

  
  
  EXEC sp_dboption 'DBName','single user','true'

  
  
  DBCC CHECKTABLE ('sysindexes',REPAIR_REBUILD)
  
  

  If this doesn't fix the problem, you may want to restore if that's a tenable option, or call Microsoft PSS. An index ID of -1 sounds ominous; I've never heard of this being negative.

  --Jonathan

  --Jonathan

  
  
  --Jonathan