Therefore that scoped transaction causes an error at the end of that stored procedure, and the active transaction…