Hi Everybody,

I wonder how to handle when a system face the following situation. If when the application is in middle of transaction (begin transaction ............end transaction), may some disasters like power failure, connection breakdown, ...etc be happened and the transactions need to rollback. I think, once the connection is reconnected again, the transactions are unable to rollback by foxpro side and have to handle by SQL Server. How should i manage if this kind of problem happened? Please Somebody guide me since I'm a fresh in this. Thanks a lot in advance.

Regards,
Mya