Error 2610

Severity Level 22

Message Text

Could not find leaf row in nonclustered index'%.*s' that corresponds to data row from logical data page %Id, row offset %d during update index attempt after data page split.

Explanation

This error most commonly occurs after insert operations when a data page is full and needs to be split. In a table with a clustered index, a data page split will occur when the row to be inserted will come sequentially after the last row in an already full page, before the first row on the next page. When this data page split occurs, the index nodes in the clustered index, and in all nonclustered indexes, must be updated.

Action

You can usually correct this error by dropping and re-creating the index.

If this error indicates a corrupt system table index, drop and recreate your system tables indexes:

USE master
go
sp_dboption <db_name>,single,true
go

USE <db_name>
go

CHECKPOINT
go

sp_fixindex <db_name>,<system_table_name>,1
go

USE master
go

sp_dboption <db_name>,single,false
go

USE <db_name>
go

If the problem persists, contact your primary support provider. Have the output from the appropriate DBCC statements available for review.