I have a quick question regarding TSTART, however not certain if there is an answer.
If I am inside the transaction and I loose connection - I always assumed that transaction would TROLLBACK, however it does not.
Is there anything special I need to set up with my TSTART, in order for this transaction to safely rollback?
As example: Let's say I am inside the TSTART and setting up / altering some data and my VPN connection got disconnected. I kind of expect all the data to be rolled back.