I am working on windows application. Suppose i am performing any updation in sql server database and my server system is off due to any reason like light problem, hang server etc.
How can i manage this problem. Now user want some message 'your server system is down unexpectedly'. and all data rollback.
Please give me any idea to manage...