FIX: Error 2610 on Insert into Table with Multiple Indexes

• Microsoft SQL Server version 6.5

SYMPTOMS

If you use "INSERT INTO <table> SELECT <select statement>" to add rows to a table that has a non-unique clustered index and at least one non- clustered index, you may encounter the following error:

Msg 2610, Level 22, State 1
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.

WORKAROUND

To work around this problem, do any one of the following:

• Make the clustered index unique.



• Drop some or all of the non-clustered indexes for the duration of the insert.



• Drop the clustered index for the duration of the insert.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider.

Keywords          : kbusage SSrvGen 
Version           : 6.5
Platform          : winnt 
Issue type        : 

Last Reviewed: April 8, 1999