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: http://stackoverflow.com/questions/3795263/insert-exec-statement-cannot-be-nested-and-cannot-use-the-rollback-statement