November 22, 2004 at 11:29 pm
I am getting the Error 8646 (SQL Server 2000), which is listed as severity 21. The standard message is [The index entry for row ID %.*hs was not found in index ID %d, of table %d, in database '%.*ls'.]
My actual text is [The index entry for row ID was not found in index ID 12 of table 71577680 in database st]
How to solve this problem?
I am looking forward to your answer,thanks.
November 23, 2004 at 12:23 am
your problem object :
select object_name(71577680)
Your problem index :
Declare @Name varchar(128)
select @Name = object_name(71577680)
exec sp_helpindex @Objname = @Name
I would run :
DBCC CHECKDB ( 'yourdb') WITH ALL_ERRORMSGS
check BOL for more options.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
November 23, 2004 at 12:46 am
Either DBCC CHECKDB or DBCC CHECKCATALOG.
I would also look for any entries in log files, check for hardware issues. Since the index ID is 12 this is a non-clustered index. So, you might want to try to drop and recreate it.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply