Loading

I need some idea

Ravi Shekhar

13y1.3k

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ravi Shekhar13y ago
I know about transaction.BUt suppose i have 5 operation in transaction . after third operation if my server is shut down automatically.how can this transaction rollback???
Iftikar Hussain13y ago
Hi,
In that case you should do all your database operation (insert/update/delete) with TRANSACTION in sql. Please refer the below link

http://www.tutorialspoint.com/sql/sql-transactions.htm

http://technet.microsoft.com/en-us/library/ms188929.aspx

Regards,
Iftikar