Question

SET_XACT_ABORT ON in a transaction with rollback present in catch block

score 189 · Answer 1 · 2013-08-28 00:32:41

189

Views

SET_XACT_ABORT ON in a transaction with rollback present in catch block

Published on 28 August 2013 at 00:32

score 2.3k · Answer 2 · 2013-09-04 15:59:06

2.3k

Views

What is the scope of XACT_ABORT

Published on 04 September 2013 at 15:59

score 697 · Answer 3 · 2014-01-09 20:07:53

697

Views

Are these code snippets equivalent ('set xact_abort on' vs 'try catch rollback')?

Published on 09 January 2014 at 20:07

score 33 · Answer 4 · 2023-11-18 07:22:02

33

Views

How to continue a transaction when OPENJSON throws an error?

Published on 18 November 2023 at 07:22

score 1.7k · Answer 5 · 2011-11-10 16:32:50

1.7k

Views

Handling Uncommitable transaction SQL SERVER

Published on 10 November 2011 at 16:32

score 373 · Answer 6 · 2018-07-28 13:31:35

373

Views

Why SQL Server stored procedure selecting encrypted data into variable fails

Published on 28 July 2018 at 13:31

score 5k · Answer 7 · 2013-04-23 15:37:35

5k

Views

Transaction handling in Trigger (TRY/CATCH....XACT_ABORT ON)

Published on 23 April 2013 at 15:37

score 418 · Answer 8 · 2021-04-06 12:08:06

418

Views

SQL Server - Try-Catch / xact_abort off and xact_state

Published on 06 April 2021 at 12:08

score 821 · Answer 9 · 2020-05-29 06:58:51

821

Views

EF Core set XACT_ABORT for all database connections

Published on 29 May 2020 at 06:58

score 942 · Answer 10 · 2015-01-23 15:07:41

942

Views

SQL Server 2005: Confusion using XACT_ABORT=ON with TRY...CATCH

Published on 23 January 2015 at 15:07

score 2k · Answer 11 · 2012-12-10 14:30:28

2k

Views

How to retrieve error code and message when distributed tx fails? (MS DTC)

Published on 10 December 2012 at 14:30

score 16k · Answer 12 · 2013-04-05 16:59:09

16k

Views

set xact_abort on and try catch together

Published on 05 April 2013 at 16:59

score 1.2k · Answer 13 · 2012-07-08 09:36:05

1.2k

Views

SET XACT_ABORT ON not Worked in Create Procedure

Published on 08 July 2012 at 09:36

score 7.2k · Answer 14 · 2012-07-23 19:36:54

7.2k

Views

How to make SET XACT_ABORT ON rollback the transaction?

Published on 23 July 2012 at 19:36

score 611 · Answer 15 · 2014-05-01 17:40:47

611

Views

SET XACT_ABORT ON Being ignored, transaction continues (SQL Server 2008 R2)

Published on 01 May 2014 at 17:40

score 206 · Answer 16 · 2018-03-08 10:26:01

206

Views

Transactions Rolling Back by default when XACT_ABORT is off

Published on 08 March 2018 at 10:26

score 6.3k · Answer 17 · 2016-07-19 14:21:37

6.3k

Views

Transactions breaking when using SP_ExecuteSQL

Published on 19 July 2016 at 14:21

score 1k · Answer 18 · 2016-06-27 19:24:03

1k

Views

SQL Server XACT_ABORT with exclusion

Published on 27 June 2016 at 19:24

score 4.1k · Answer 19 · 2021-11-05 07:15:51

4.1k

Views

How to use SET XACT_ABORT ON the right way

Published on 05 November 2021 at 07:15

score 2.5k · Answer 20 · 2012-11-08 14:31:28

2.5k

Views

What is the effect of having XACT_ABORT on/off in parent/child stored procedures respectively?

Published on 08 November 2012 at 14:31

List Question

SET_XACT_ABORT ON in a transaction with rollback present in catch block

What is the scope of XACT_ABORT

Are these code snippets equivalent ('set xact_abort on' vs 'try catch rollback')?

How to continue a transaction when OPENJSON throws an error?

Handling Uncommitable transaction SQL SERVER

Why SQL Server stored procedure selecting encrypted data into variable fails

Transaction handling in Trigger (TRY/CATCH....XACT_ABORT ON)

SQL Server - Try-Catch / xact_abort off and xact_state

EF Core set XACT_ABORT for all database connections

SQL Server 2005: Confusion using XACT_ABORT=ON with TRY...CATCH

How to retrieve error code and message when distributed tx fails? (MS DTC)

set xact_abort on and try catch together

SET XACT_ABORT ON not Worked in Create Procedure

How to make SET XACT_ABORT ON rollback the transaction?

SET XACT_ABORT ON Being ignored, transaction continues (SQL Server 2008 R2)

Transactions Rolling Back by default when XACT_ABORT is off

Transactions breaking when using SP_ExecuteSQL

SQL Server XACT_ABORT with exclusion

How to use SET XACT_ABORT ON the right way

What is the effect of having XACT_ABORT on/off in parent/child stored procedures respectively?

Trending Questions

Popular # Hahtags

Popular Questions