losing ms sql server2000 data

[mediromi]

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 also say that there is no DELETE sql command in any applications, store procedures & sql jobs. ( I flag records as Deleted rather than actually deleting. in addition, there is a triger on my victim table that says in case of delete command, delete a record from another table that guaranties no delete command should be executed on this table alone without expecting another delete in the second table.

I have also disabled all ms sql jobs, sprocs. and there is no database user with DELETE permission ( even sa )

I tried to monitor everything with Profiler but shows nothing unnormal and that why I am absolutely shook now !!!

Could anyone help me with this prob please?


Thank you

Regarads,
Medi