Skip to content Skip to sidebar Skip to footer
Home / Ado.net / Sql / Sql Server / Transactions

How To Set Xact_abort Within Ado.net

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

Solution 1:

Execute SET XACT_ABORT ON or SET XACT_ABORT OFF.

Solution 2:

There is no client setting: in SQL As Remus said.

SET XACT_ABORT is not a property of the connection, command or transaction and can be set/unset at any time in SQL Code. There is no ado.net options for SET NOCOUNT ON etc.

Post a Comment for "How To Set Xact_abort Within Ado.net"