transaction question

  • Thread starter Thread starter Daniel
  • Start date Start date
D

Daniel

What happen if I have a SQLServer database and in my application I have
started a transaction, with 5 operations of 7 and suddenly the application
is crashed and stopped and no rollback is invocated, what happen with the
information? Will it be saved in database or unsaved in the tables because
no commit have been done?
 
The transaction rollback is guaranteed if no commit has been called and the
connection is closed. In the case of an application crash where the process
is terminated the connection is closed, and therefore the transaction is
rolled back.
Hope this helps,
 
Thanks, I think it will.

Angel Saenz-Badillos said:
The transaction rollback is guaranteed if no commit has been called and the
connection is closed. In the case of an application crash where the process
is terminated the connection is closed, and therefore the transaction is
rolled back.
Hope this helps,
--
Angel Saenz-Badillos [MS] Managed Providers
This posting is provided "AS IS", with no warranties, and confers no rights.
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.
Daniel said:
What happen if I have a SQLServer database and in my application I have
started a transaction, with 5 operations of 7 and suddenly the application
is crashed and stopped and no rollback is invocated, what happen with the
information? Will it be saved in database or unsaved in the tables because
no commit have been done?
Click to expand...
Click to expand...
 
Back
Top