I have a Winforms application that calls a webservice method
The webservice method starts a long running transaction (unfortunately there are lots of little commands as opposed to one long running one.)
As far as I can see if the webservice call times out the transaction in the the webservice method will continue to run and complete. What I would like to happen would be for the transaction to rollback when the webservice timesout. Is this possible?
Reviving an old thread, but I have had the same problem, so thought I would update this for anyone else that comes across it. The best solution I have found is to use XACT_ABORT ie insert
SET XACT_ABORT ONat the start of your transaction. This will force a rollback for any type of client error (so your transaction will not continue to run and complete, it will just rollback). There is a really good discussion on it in the dba stackexchange:
https://dba.stackexchange.com/questions/10912/sql-server-transaction-timeout