Data loss in MS SQL server - TechRepublic
General discussion
May 9, 2002 at 05:43 PM
eric_ting

Data loss in MS SQL server

by eric_ting . Updated 24 years, 1 month ago

I use visual Basic and SQL server 7.0 to write a program for data capturing. The program is used by more than 10 operators. When I find a blocking occurs, I kill the blocking process. And it is reported that thousands of records captured are loss. Iam sure there the transaction is COMMIT after every valid transaction. I think only one record can be lost rather than thousand of records.
Why this happen and what is the machanism of SQL server handle the data?

This discussion is locked

All Comments