I am having an Storedprocedure with another sp calling from it. Both outer
and inner sp has transaction.
In the inner sp,it has a failure condition and rollback transaction with certain input.
Now,getting message as
"Transaction count after EXECUTE indicates a mismatching number of BEGIN and
COMMIT statements. Previous count = 1, current count = 0."
When i checked the transcount with @@trancount,it was one before entering inner sp and
becomes zero when rollback.
There is no try catch used.
Any help to eliminate this error will be helpful.