Cannot use the ROLLBACK statement within an INSERT-EXEC statement [duplicate]
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?
精彩评论