Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
amitm79
Starting Member
5 Posts |
 Posted - 2004-07-12 : 03:34:45
|
| 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 statement2> 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 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-12 : 08:23:33
|
| You might want to drop and recreate the indexes on this table and see if that fixes it.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
Error 644