>Reyqie,
>
>SQL Server cannot prevent data loss if your data entry PCs are "freezing".

Which is why I suggested that he focused on fixing the real problem in stead of looking for stronger "medicine" to relieve the pain.

>The first step is to check the power supply not just for the Server and PCs but for routers, network hardware, dsl or cable modems, apparently unrelated servers providing proxy or windows network services... anything where a momentary glitch can cause an apparent freeze. It might be just one PC messing your whole system up- we had a client whose IT support person had a flaky network card so every he logged in to "investigate", users began experiencing lockups and data loss.
>
>Good luck!