Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How to set XACT_ABORT within ADO.NET

Tags:

sql

sql-server

ado.net

transactions

How can I set XACT_ABORT to ON (or OFF) from within ADO.NET ?

like image 395
Kingamoon Avatar asked Dec 10 '22 17:12

Kingamoon

1 Answers

Execute SET XACT_ABORT ON or SET XACT_ABORT OFF.

like image 130
Remus Rusanu Avatar answered Dec 23 '22 16:12

Remus Rusanu
Sign in to Comment

Related questions

SQL Server 2005 stored procedure performance problem
What's the best way to store (and access) historical 1:M relationships in a relational database?
Where do you put your SQL Queries? [closed]
Tidy for SQL
MySQL 1 millon row query speed
How to set connection pool to 100 in sql server 2005 instance
SQL query for finding the first, second and third highest numbers
What is the purpose of tbl_Product, tbl_Order naming conventions?
SQL Server Stored Procedures: do they queue up?
T/F: Using IF statements in a procedure produces multiple plans
Using ORM with stored procedures, a contradiction?
Group by selects first occurence of field how can I get the last one?
How to turn this MySQL SELECT query into a DELETE query?
Invalid Number Error! Can't seem to get around it
Find a string within the source code (DDL) of a stored procedure in oracle
Does SQL's DELETE statement truly delete data?
SQL Select Into Field
SqlError.Number descriptions
SQL : find rows and sort according to number of matching columns?
Design question: Filterable attributes, SQL

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!