I have two stored procedures, one of which calls the other (see sample
below). When I provide data that I know will generate an error in add_a, I
Msg 266, Level 16, State 1
Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRAN is
missing. Previous count = 1, Current count = 0.
Msg 3903, Level 16, State 1
The rollback transaction request has no corresponding BEGIN TRANSACTION.
If I wrap the calling code in a begin/commit transaction, I get two of these
error messages. Anyone know why?
create procedure add_a
.... (do some sql stuff) ....
create procedure add_b