title: Cannot use the ROLLBACK statement within an INSERT-EXEC statement
body: <p><strong>Cannot use the ROLLBACK statement within an INSERT-EXEC statement</strong></p>
  
  <p>I am using two stored procedures. the first sp returns some int value</p>
  
  <p>I am using this in the second sp with <strong>INSERT EXEC</strong></p>
  
  <p>But when i am executing the second sp , I am getting the above error</p>
  
  <p>Please help</p>