July 12, 2004 at 1:39 am
Hi All,
I am getting an error 644 while running a database manipulation script on a database (its working on many other databases). Can
anybody tell me why is it happening? Some of the specifcs about the operation are:
1> The error is occurring on a DELETE statement
2> DELETE is being performed in batches of 200000 rows.Each batch is in BEGIN TRAN, END TRAN block.
3> The database isolation level is READ COMMITTED(the default). MS has some hotfix for DELETE on READ UNCOMMITTED isolation level.
4> My table has one composite index (Primary key) comprising of 5 columns.
5> I don't have any Unicode column in my table. Microsoft has some hotfix related to this error in case the column datatype is unicode with some specific collation.
6> My SQL version is 8.00.760.
7> DBCC CHECKDB with REPAIR_REBUILD does not return me any error.
Regards,
amitm79
July 15, 2004 at 6:44 am
The BOL entry for error 644 says it is a non clustered index error - trying to delete a record that doesn't physically exist in the table.
You don't say if your composite index is a clustered index. It should be if it isn't. Have you tried the next suggestion in BOL, which is to remove the index and rebuild it (possibly after the deletes). If this allows you to delete the records it still doesn't solve the problem of what was wrong with the index (sounds very much like a bug somewhere in SQLServer).
Peter
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply