I have a MS SQL 2005 stored procedure that executes 4 other stored procedures. Each proceedure that executes relies on the completion of the previous in order to perform correctly. The trouble I'm having is that it appears that procedure 3 doesn't finish or commit it's work before procedure 4 runs.
If I manually execute the procedures in order everything works correctly.
My gut feeling is that this has something to do with the fact that I have row versioning turned on.
Is there a way to make sure that procedure 3 completes and commits it's data before procedure 4 executes.