Hi, I have a massive sql 2000 database that an asp web application uses it. the problem is that one of tables is losing its records automatically without any logical reason. I have to also say that there is no DELETE sql command in any applications, store procedures & sql jobs. ( I flag records as...

Just check the following links to see whether you have followed same process: http://msdn.microsoft.com/library/en-us/adminsql/ad_bkprst_4g4w.asp & http://msdn2.microsoft.com/en-US/library/aa213831(sql.80).aspx