@@transtate contains the current state of a transaction after a statement executes in the current user session. However, unlike @@error, @@transtate does not get cleared for each batch. @@transtate may contain the values in Table 14-3:
Value |
Meaning |
|---|---|
0 |
Transaction in progress: an explicit or implicit transaction is in effect; the previous statement executed successfully. |
1 |
Transaction succeeded: the transaction completed and committed its changes. |
2 |
Statement aborted: the previous statement was aborted; no effect on the transaction. |
3 |
Transaction aborted: the transaction aborted and rolled back any changes. |
@@transtate only changes due to execution errors. Syntax and compile errors do not affect the value of @@transtate. See “Checking the state of transactions” for examples showing @@transtate in transactions.
