Cannot use ROLLBACK statement in INSERT-EXEC statement

Question

Cannot use ROLLBACK statement in INSERT-EXEC statement

I use two stored procedures. first sp returns some int value

I use this in second sp with INSERT EXEC

But when I execute the second sp, I get the above error

Please, help

Answer 1

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