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