Post reply

Index Issue

  • July 5, 2004 at 6:52 pm

    #83419

    A customer I deal with is still using MSSQL 6.5 and they received the following error when trying to delete some data:

    "The non_clustered leaf row entry for page 114627 row 2 was not found in endex page 936356 indexid 6 database MTA_DW"

    What could be the cause of this?

    Thanks,

    Kevin

  • July 5, 2004 at 7:34 pm

    #513367

    The Index is corrupt!

    Perform a consistency check on the Database and then either perform a DBCC DBREINDEX or DROP it & Re-Create it, then perform the delete operation again!

    Kindest Regards,

  • July 7, 2004 at 11:46 am

    #513708

    DBCC DBREINDEX does not work on SQL 6.5.  You can run DBCC CheckTable (tablename).  You could also try DBCC CheckAlloc (databasename) or DBCC NewAlloc (databasename).

    Linda

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

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