To Speed up searching, I create indices on some varchar Field. The indices can be created successfully.
But when I update or insert records, the server will generate 644 Error! It's caused by corrupted indices.
I had followed the steps in Book Online to find and fix the corrupted indices successfully.
But the Error 644 will appear again when I update or insert records into indexed tables.
I can't fix the corrupted indices everyday, just hope there is a way to fix the bug forever.
My Server is MS SQL 6.5(SP4), NT Server 4.0(SP3,I386), Please help me