@@TranState

Contains the state of the current transaction

@@TranState	Description
0	Transaction in progress
1	Transaction committed
2	Previous statement aborted Transaction still in progress
3	Transaction aborted and rolled back