Post reply

index entry

  • October 23, 2008 at 6:47 am

    #195052

    Got this error message in sql server error log:

    The index entry for row ID was not found in index ID 8, of table 437576597, in database 'NEWDB'.

    I need to find the table name? can i find with the above statement?

    thanks,

  • October 23, 2008 at 7:00 am

    #888575

    select object_name(437576597)

  • October 23, 2008 at 11:24 pm

    #889032

    Ian Scarlett (10/23/2008)

    select object_name(437576597)

    Thanks for the updation. This is worthful

    kshitij kumar
    kshitij@krayknot.com
    www.krayknot.com

  • October 24, 2008 at 4:04 am

    #889107

    You may want to run a full checkDB on that database to be sure there's no more corruption. From the looks of things, that error can be fixed by dropping and recreating whatever index it's talking about, but there may be more problems.

    select object_name(437576597), name from sysindexes where id = 437576597 and indid = 8

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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