Interrupt connection without both Rollback

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

Interrupt connection without both Rollback

Author

Topic

Ciupaz
Posting Yak Master

232 Posts

Posted - 2013-04-04 : 04:40:23

Hello all,
in SQL Server 2008 if the connection between my application and the database is broken during a long Update execution under a transaction, what happen? A rollback is call or a commit?

Luigi

bandi
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2013-04-04 : 04:46:22

Roll back will happen...
Refer the following link ("Errors During Transaction Processing")
http://msdn.microsoft.com/en-us/library/ms175523(v=sql.105).aspx