Cannot use the ROLLBACK statement within an INSERT-EXEC statement [duplicate]

This question already has answers here: Errors: "INSERT 开发者_StackOverflow社区EXEC statement cannot be nested." and "Cannot use the ROLLBACK statement within an INSERT-EXEC statement." How to solve this? (13 answers) Closed 8 years ago.

Cannot use the ROLLBACK statement within an INSERT-EXEC statement

I am using two stored procedures. the first sp returns some int value

I am using this in the second sp with INSERT EXEC

But when i am executing the second sp , I am getting the above error

Please help

---

Take a look at this link. Hope it helps: Errors: "INSERT EXEC statement cannot be nested." and "Cannot use the ROLLBACK statement within an INSERT-EXEC statement." How to solve this?