Transaction rollback on connection failure or timeout

Question

This question is asked by Navaneeth Adruguli on Link Of form

The question is:
In SQL server how transaction rollback will work? If i have a huge number of updates in a transaction and during update connection failure or connection timeout occurs then what will happen?Can sql server rollback in this conditions without connection to the sql server(in case of conection failure).If possible then how?

This question is already answered on this other forum. Why post it here? Are you expecting a different answer? — Mike Brant, Jun 20 '13 at 17:53

score 0 · Answer 1 · answered Jun 20 '13 at 17:52

0

SQL Server rollback the transaction if any error occurs in network of system. It can even automatically restore from crash if system crashes or shuts down in between.

answered Jun 20 '13 at 17:52

Ankit Zalani

3,068
5
27
47

thanks for your attention, but what will be happen if network losses from client computer. – harry34 Jun 22 '13 at 05:57

Transaction rollback on connection failure or timeout

1 Answers1