>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?

What kind of "freeze" are you talking about?... many people default to 'frozen' as soon as a keystroke or mouse click seems to be ignored by the system or they get "not responding' in an application's window title line.
1) Have they been IN the application working with it or have they been away from it (in another application or at lucnh, etc) and then come back to it and found it frozen at that point?
2) Do the workstations in question have "write behind cache" enabled for their HDs. If so, ensure it is DISABLED.
3) Do the workstations in question have power saving features enabled for their network adapters? If so, ensure they are set to no powersaving.
4) Do the workstations in question have 'network drives (letters) defined that are no longer valid? If so, remove them.
5) I have cases where something (Outlook 2003 I believe) "freezes my workstation for 30-40 seconds. the only "solution" is PATIENCE". Might your workstations have the same problems?
6) Are the workstations in questions using wireless for network connections? If so, change to wired.

If any of the above apply, I don't think that SQL Server will be of much help.
SQL Server is certainly a "more reliable/robust" database overall, but it isn't necessarily the answer to everything.

good luck