index entry

  • 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,

  • select object_name(437576597)

  • Ian Scarlett (10/23/2008)


    select object_name(437576597)

    Thanks for the updation. This is worthful

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

  • 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