SQLServer Dropping Records?

Is ASP or my database dropping records?

[ratebeer]

It's been a nagging problem... users report occasional report that one or more of thier records were dropped. This happened to me once. A few of my recent ratings (last couple weeks) were somehow dropped.

An admin reports that every few days we lose 8 records or so. We have 400,000+ but that number is horrifying to me. We've gone over the update and delete record ASP and SQL and can't find anything.

Has nayone heard of such a problem with SQLServer dropping records?

[txbakers]

databases as a rule don't drop records.

The code to display then (queries and such) sometimes don't read/write correctly.

And, if you're updating/deleting from multiple tables, it could be that one table gets affected and the other doesn't. (transaction processing)

[TheNige]

Yes, check for multiple updates tables etc...maybe the data was never written. And use transactions if you are doing multiple data inserts deletes that depend on each other.

[Easy_Coder]

You've got yourself a bug in your code...