title: Finally Clause in SQL Server Transaction? Something that will execute irrespective of success or failure?
body: <p>In SQL Server, is there something similar to <code>finally</code> clause in <code>try..catch...</code> block of c# ?</p>
  
  <p>I mean, I am using <code>BEGIN TRAN, END TRAN, COMMIT TRAN, ROLLBACK TRAN</code> etc in a SQL Server transaction and want a section or some set of actions that needs to fire irrespective of success or failure or transaction. </p>
  
  <p>Is there a solution for that? (similar to finally block on try/catch of OOPS languages). </p>
  
  <p>Thanks in advance</p>