SQLServer Dropping Data

Is this is a transact SQL problem?

[ratebeer]

Our database still drops records for no apparent reason and has been doing this for over a year. Recently we lost several hours of new data suddenly and without cause.

We have no idea why our database is doing this. We've been tidying up code for a long time have found no culprit. I was wondering if any element of a transaction could be responsible for this?

Any ideas?

[IanTurner]

Transaction failures due to database locks are a possibility. This might well cause a transaction to rollback and data to be lost, you should be able to check the transaction log to see what is happening.