Within the CATCH block, you can commit you can commit or roll the current transaction unless the transaction cannot be committed and must be rolled back. To test for the state of the transaction, you can query the EXACT_STATE function.