title: ALTER PROCEDURE with TRANSACTION
body: <p>I need to modify approx. 24 huge UDP and for production deployment i need to do a BEGIN TRANSACTION / ROLLBACK / COMMIT PROCESS.</p>
  
  <p>How can I add the <code>ALTER PROCEDURE my_proc</code> between BEGIN TRANSACTION and COMMIT or ROLLBACK?</p>
  
  <p><strong>Note</strong>: <code>EXEC('ALTER PROCEDURE..')</code> can <strong>NOT</strong> be implemented. </p>
  
  <p>Thanks</p>
  
  <p>Update: there is a way to alter a procedure and rollback if it fails?</p>