Very strange behavior of SS2K...

[Ach]

Hi all,
I face a problem as follows: We have an application runnig on SS2K.We log every delete of documents(from Archive table) in another table.Now it seems some of the rows have deleted strangely without any delete log by our application.We assumed there is somebody who has direct access to database and delete them manually(obviousely our app does not generate any log in this situation)But there is no people.We check that with admins many times.
Does SQL Server itself deletes rows for any reason? How can I know what is happening?Do you think our app flaws somewhere?
Thanks a lot for your attention.

[rmiao]

You can trace it with profiler.

[skhanal]

How do you log the delete? Do you use trigger?

SQL Server does not delete rows from a table by itself, it's not that intelligent.

One option you can consider is to get a log miner tool (e.g. Log Explorer from Lumigent) and browse the transaction log file (backup and live).

[Ach]

We log a delete whenever a customer push a delete buttom in our application.
It is a seperate thing from Transaction_Logs in SS2K.
-Thanks

[rmiao]

If you log those actions in sql db, still can find those transactions in db's transaction log.