I didn't catch if it was mentioned specifically, but I got the impression that the answer to my question is yes, but I'll ask anyways: Do transactions work with sub procedures and functions, or can they only rollback what is in the procedure in which they are written? For example, if instead of writing out each SQL execution I used a for..next loop to send multiple order items to a nested procedure.