In simple terms, wrap the three steps in an explicit transaction.

BEGIN TRANSACTION

step 1;

step 2;

step 3;

COMMIT;

There may be more to this if you are looking at adding any kind of error handling to the process. Since you appear to be using SQL Server 2000 at this point, I will leave addressing that to others as it has been years since I have worked with that version of SQL Server.