What is the benefit of using “SET XACT_ABORT ON” in a stored procedure? June 1, 2022 by IT Nursery What is the benefit of using SET XACT_ABORT ON in a stored procedure? 5 Answers 5