Is there any parameter to prevent long transactions? I would like to automatically rollback all transaction that takes more than 5 minutes. Is it possibile? I'm working on a Microsoft SQL server 2008 R2.
Background notice:
I'm asking this because I'm working with many awful application: In case of application exception they show a modal alert, transaction is released ONLY when the alert is closed. I really know this seems a joke, but it isn't! I can not change this apps and I can not fire their developers but I need to solve this problem: long transaction (can be also a simple transaction with low cost) must take less then 5 minute. Otherwise some tables will be locked until modal close.