Cannot use the ROLLBACK statement within an INSERT-EXEC statement

Question

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

Answer 1

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?