Post reply

DBCC CHECKTABLE

  • February 19, 2004 at 11:32 am

    #161504

    Hi,

    I'm running SQL 2000 sp3 and win 2000 sp4.  I get this error when I run checktable.

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

    Could not find row in sysindexes with index ID -1 for table 'Network_Inv'.

    I checked sysobjects and syscolumns and they both have records for this table, but sysindexes does not.  Any ideas what to do next.

    Thanks

  • February 19, 2004 at 12:01 pm

    #494767

    What indexes does the table have? Run dbcc checkdb to see whether you have any errors.

  • February 19, 2004 at 12:12 pm

    #494770

    The Table should have 15 indexes.  When I run dbcc checkdb I get.

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

    Could not find row in sysindexes with index ID -1 for table 'Network_Inv'.

    Any ideas?

     

  • February 19, 2004 at 12:19 pm

    #494771

    No idea why you got index id -1 here. What you can do is to rebuild the indexes and dbcc checktable back to see same error still occurs. If it is, then try to run dbcc checktable with repair option. See BOL for details.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply