title: Errors: "INSERT EXEC statement cannot be nested." and "Cannot use the ROLLBACK statement within an INSERT-EXEC statement." How to solve this?
body: <p>I have three stored procedures <code>Sp1</code>, <code>Sp2</code> and <code>Sp3</code>.</p>
  
  <p>The first one (<code>Sp1</code>) will execute the second one (<code>Sp2</code>) and save returned data into <code>@tempTB1</code> and the second one will execute the third one (<code>Sp3</code>) and save data into <code>@tempTB2</code>.</p>
  
  <p>If I execute the <code>Sp2</code> it will work and it will return me all my data from the <code>Sp3</code>, but the problem is in the <code>Sp1</code>, when I execute it it will display this error:</p>
  
  <blockquote>
    <p>INSERT EXEC statement cannot be nested</p>
  </blockquote>
  
  <p>I tried to change the place of <code>execute Sp2</code> and it display me another error:</p>
  
  <blockquote>
    <p>Cannot use the ROLLBACK statement
    within an INSERT-EXEC statement.</p>
  </blockquote>