Home / Software / Tips and Tricks / What is the use of XACT_STATE in try catch blocks?

What is the use of XACT_STATE in try catch blocks?

Updated:  07/14/2014 10:07 AM
Author:  Shiju Mathews

Status:    Resolved.


he XACT_STATE function determines whether the transaction should be committed or rolled back. if XACT_ABORT is ON transaction uncommittable when the constraint violation error occurs.