title: SQL Server - Set a timeout / automatic ROLLBACK on TRANSACTION
body: <p>With <code>TRANSACTION</code>, is there a way to have it <code>ROLLBACK</code> automatically after X number of seconds? This way you'd prevent accidentally leaving a <code>TRANSACTION</code> open and locking the database.</p>