This is a corruption in your database, run dbcc checkdb and dbcc newalloc on
the database in question.
Usually dropping and recreating the nonclustered indexes, and perhaps the
clustered one will fix your particular problem.
The corruption may point to a problem on your disks so hardware checks might
Also, make sure your running with the latest service pack of 6.5.
Tony Rogerson SQL Server MVP
Torver Computer Consultants Ltd
www.sql-server.co.uk (UK User group, code library, FAQ etc..)
> When I want to create table or create trigger, the following error occurs:
> Error 2610:[SQL SERVER] Could not find leaf row in nonclustered index
> 'ncsysobjects' that corresponds to data row from logical data page 5, row
> offset 6 during update index attempt after data page split.
> The error usually occurs after I create some talbes and triggers, then I
> can't create tables any more.
> The Sqlserver version is v6.5 .
> Would you please tell me how to fix this problem?
> Fang Jing