Error 8646! URGENT! HELP!

Hello ALL!
I got strage problem. While perfoming long update i got error 8646 (The inde
x entry for row ID was not found in index ID 2, of table 641098466, in data
base 'MyBase').
At microsoft site i found: 'FIX: Error 644 or 8646 May Occur During a DELETE
or UPDATE Against a Table That Contains a Unicode Column with a Latin1_Gene
ral_BIN Collation'
But my collation is SQL_Latin1_general_CP1251_CI_AS and that table 64109846
6 have not Unicode Columns.
What is wrong?What does DBCC CHECKDB and DBCC CHECKCTALOG say? Any errors? You might just
have some database corruption.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Volhv" <anonymous@.discussions.microsoft.com> wrote in message
news:9E597526-356A-435A-A760-629C1141A3F9@.microsoft.com...
> Hello ALL!
> I got strage problem. While perfoming long update i got error 8646 (The
index entry for row ID was not found in index ID 2, of table 641098466, in
database 'MyBase').
> At microsoft site i found: 'FIX: Error 644 or 8646 May Occur During a
DELETE or UPDATE Against a Table That Contains a Unicode Column with a
Latin1_General_BIN Collation'
> But my collation is SQL_Latin1_general_CP1251_CI_AS and that table
641098466 have not Unicode Columns.
> What is wrong?
>|||All DBCC comand say nothing. After this error i run
dbcc checktable & dbcc dbreindex
After this all work fine until next ocurency of this error|||In addition to Tibor's suggestion,
Be watchful of potential hardware error which may be causing this... AND
since the index ID is = 2, this is a non-clustered index... You might try to
drop and re-create the non-clustered index...
Wayne Snyder MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
(Please respond only to the newsgroups.)
I support the Professional Association for SQL Server
(www.sqlpass.org)
"Volhv" <anonymous@.discussions.microsoft.com> wrote in message
news:9E597526-356A-435A-A760-629C1141A3F9@.microsoft.com...
> Hello ALL!
> I got strage problem. While perfoming long update i got error 8646 (The
index entry for row ID was not found in index ID 2, of table 641098466, in
database 'MyBase').
> At microsoft site i found: 'FIX: Error 644 or 8646 May Occur During a
DELETE or UPDATE Against a Table That Contains a Unicode Column with a
Latin1_General_BIN Collation'
> But my collation is SQL_Latin1_general_CP1251_CI_AS and that table
641098466 have not Unicode Columns.
> What is wrong?
>|||Yes its non-clustered index and i done drop and re-create...
Hardware problem...i do not think so. I shrink base, defragment, recreating
and so on. I think real place of this index derfert after this operations a
nd problem occured only in one table. This table at the and of transaction a
nd data move to it via trig
ger.