Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    9

    Question Unanswered: Error: 644, Severity: 21, State: 6

    Hi All

    Ignore the error below, It's got to do with isolation levels (nolock in this case): refer http://support.microsoft.com/?kbid=834290 for details.

    Error: 644, Severity: 21, State: 6
    Could not find the index entry for RID '1631393920202020202020202020202033392020202020202 020202020202019bcd3113230303037333120202020202020' in index page (1:420134), index ID 0, database 'DBName'..

    What I'd like to know is how to get the table name that was affected out of this error message. Do I query sysindexes, sysobjects, use a function or something else?

    Thanks in advance.

    Graham
    Last edited by Gee.Bob; 11-11-04 at 03:13. Reason: Changed Db name

  2. #2
    Join Date
    Sep 2004
    Posts
    9
    No need to answer the question:

    dbcc traceon(3604)
    dbcc page ('DBName', 1, 420134, 0)
    select name from sysobjects where id =1141579105---m_objId from page header
    dbcc traceon(3604)
    dbcc page ('DBName', 1, 305272,0)
    select name from sysobjects where id =1141579105---m_objId from page header
    dbcc traceon(3604)
    dbcc page ('DBName', 1, 369029, 0)
    select name from sysobjects where id =2021582240---m_objId from page header

    /*
    TABLE A: DBCC PAGE Parameters
    Parameter Description
    dbid ID of the database containing the page
    dbname Name of the database containing the page
    filenum File number containing the page
    pagenum Page number within the file
    printopt Optional print option; takes one of these values:
    0 Default; print the buffer header and page header
    1 Print the buffer header, page header, each row separately, and the row offset table
    2 Print the buffer and page headers, page as a whole, and the offset table

    */

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •