>Is there a way to prevent data lost or data corruption?
>
>We are requiring UPS and implementing Flush commands in our application, but there are instance the the Computer Freezes or Hangs in the middle of transactions which causes data lost or corruption. Is there a bullet proof solution for this problem. If we move the database from Visual Foxpro to SQL Server will this solve data lost and data corruption?


Sure there is.
It is called buffering/transactions and it works.
I reccomend optimistic table buffering (5) rounded up into
transaction.
See VFP manual for details.

I almost forgot all bout corruption.

hth