List Question
20 TechQA 2023-11-18T07:22:02.267000How to continue a transaction when OPENJSON throws an error?
77 views
Asked by user1828271
How to use SET XACT_ABORT ON the right way
4.2k views
Asked by Francesco Mantovani
SQL Server - Try-Catch / xact_abort off and xact_state
463 views
Asked by Adrian Parker
EF Core set XACT_ABORT for all database connections
870 views
Asked by l3utterfly
Why SQL Server stored procedure selecting encrypted data into variable fails
411 views
Asked by Maxim
Transactions Rolling Back by default when XACT_ABORT is off
240 views
Asked by SE1986
Why does SQL Server default XACT_ABORT to OFF? Can it be set to ON globally?
9.5k views
Asked by HappyTown
Transactions breaking when using SP_ExecuteSQL
6.3k views
Asked by Ivan Pintar
SQL Server XACT_ABORT with exclusion
1k views
Asked by Eli
SQL Server 2005: Confusion using XACT_ABORT=ON with TRY...CATCH
998 views
Asked by RobW
SET XACT_ABORT ON Being ignored, transaction continues (SQL Server 2008 R2)
636 views
Asked by test-in-prod
Are these code snippets equivalent ('set xact_abort on' vs 'try catch rollback')?
741 views
Asked by Anatoly U
What is the scope of XACT_ABORT
2.4k views
Asked by Guillermo GutiƩrrez
SET_XACT_ABORT ON in a transaction with rollback present in catch block
240 views
Asked by TheWommies
Transaction handling in Trigger (TRY/CATCH....XACT_ABORT ON)
5.1k views
Asked by Ramon Gonzalez
set xact_abort on and try catch together
16k views
Asked by satuday
Trigger exits on first failed insert and cant set xact_abort OFF in SQL Server 2000
952 views
Asked by LDM
How to retrieve error code and message when distributed tx fails? (MS DTC)
2.1k views
Asked by spse
What is the effect of having XACT_ABORT on/off in parent/child stored procedures respectively?
2.5k views
Asked by Will Weld
How to make SET XACT_ABORT ON rollback the transaction?
7.2k views
Asked by Ian Boyd