To start a transaction, use BEGINTRANS
To make the changes final, use COMMITTRANS
To undo all changes made since calling begintrans, call ROLLBACKTRANS

You may be calling your begintrans at the wrong time, or not at all. If you are going to use transactions, be sure to be clear on when to use them