Can't you define a transaction through your application and call all 3 stored procedures from within that one transaction? I don't have alot of experience from the application side of SQL Server, but I believe this is how our developers do it. There are times when we control the transactions using the TRANSACTION, COMMIT, and ROLLBACK keywords inside our stored procedures, but we do have instances where the transaction scope is handled through the ADO connection.