StackOverflow Questions for Tag: xact-abort

HappyTown

Reputation: 6514

Why does SQL Server default XACT_ABORT to OFF? Can it be set to ON globally?

sql-servert-sqltransactionsxact-abort

Score: 14

Answers: 1

MilConDoin

Reputation: 745

SET XACT_ABORT ON in multi-database scenario from .NET

c#sql-servertransactionscopexact-abort

Score: 0

Answers: 0

Francesco Mantovani

Reputation: 12227

How to use SET XACT_ABORT ON the right way

sql-servert-sqltry-catchrollbackxact-abort

Score: 10

Answers: 3

satuday

Reputation: 165

set xact_abort on and try catch together

sql-servertry-catchxact-abort

Score: 9

Answers: 2

Harold

Reputation: 13

How to continue a transaction when OPENJSON throws an error?

sqltransactionsxact-abort

Score: 0

Answers: 0

Santy

Reputation: 85

Handling Uncommitable transaction SQL SERVER

sql-server-2008transactionstry-catchxact-abort

Score: 0

Answers: 1

Adrian Parker

Reputation: 1

SQL Server - Try-Catch / xact_abort off and xact_state

sql-servertry-catchxact-abort

Score: 0

Answers: 0

Ivan Pintar

Reputation: 1881

Transactions breaking when using SP_ExecuteSQL

sql-servertransactionssql-server-2014xact-abort

Score: 5

Answers: 2

l3utterfly

Reputation: 2186

EF Core set XACT_ABORT for all database connections

sql-serverentity-frameworkentity-framework-corexact-abort

Score: 1

Answers: 1

Guillermo Gutiérrez

Reputation: 17799

What is the scope of XACT_ABORT

sql-serversql-server-2005scopesqltransactionxact-abort

Score: 19

Answers: 1

Ian Boyd

Reputation: 256671

How to make SET XACT_ABORT ON rollback the transaction?

sql-serversql-server-2008-r2xact-abort

Score: 8

Answers: 2

Maxim

Reputation: 23

Why SQL Server stored procedure selecting encrypted data into variable fails

sql-serveralways-encryptedxact-abort

Score: 2

Answers: 1

SE1986

Reputation: 2750

Transactions Rolling Back by default when XACT_ABORT is off

sql-servertransactionssql-server-2014xact-abort

Score: 2

Answers: 2

Will Weld

Reputation: 328

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

t-sqlerror-handlingxact-abort

Score: 6

Answers: 2

Eli

Reputation: 2608

SQL Server XACT_ABORT with exclusion

sql-serverxact-abort

Score: 3

Answers: 3

Ramon Gonzalez

Reputation: 251

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

sqltriggerssql-server-2008-r2sqltransactionxact-abort

Score: 4

Answers: 1

RobW

Reputation: 128

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

sqlsql-serversql-server-2005try-catchxact-abort

Score: 0

Answers: 1

test-in-prod

Reputation: 498

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

sql-servert-sqlsql-server-2008-r2xact-abort

Score: 0

Answers: 2

TheWommies

Reputation: 5072

SET_XACT_ABORT ON in a transaction with rollback present in catch block

transactionsxact-abort

Score: 0

Answers: 0

Anatoly U

Reputation: 258

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

sql-serverxact-abort

Score: 4

Answers: 1

PreviousPage 1Next

StackOverflow Questions for Tag: xact-abort

Why does SQL Server default XACT_ABORT to OFF? Can it be set to ON globally?

SET XACT_ABORT ON in multi-database scenario from .NET

How to use SET XACT_ABORT ON the right way

set xact_abort on and try catch together

How to continue a transaction when OPENJSON throws an error?

Handling Uncommitable transaction SQL SERVER

SQL Server - Try-Catch / xact_abort off and xact_state

Transactions breaking when using SP_ExecuteSQL

EF Core set XACT_ABORT for all database connections

What is the scope of XACT_ABORT

How to make SET XACT_ABORT ON rollback the transaction?

Why SQL Server stored procedure selecting encrypted data into variable fails

Transactions Rolling Back by default when XACT_ABORT is off

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

SQL Server XACT_ABORT with exclusion

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

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

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

SET_XACT_ABORT ON in a transaction with rollback present in catch block

Are these code snippets equivalent (&#39;set xact_abort on&#39; vs &#39;try catch rollback&#39;)?

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