Can't find docs aboout transaction XACT_ABORT
Can somebody give me a link with a proper configuration for transactional XACT_ABORT setting?
Maybe it's ON by default? I haven't found any mention of it
Anyone?
I cannot add a great deal - this driver is essentially a little java script wrapped around the ODBC c++ API. I do not think there is a way to set this via ODBC but could be wrong.
this article seems to suggest it is off by default with a session, you would have to issue the commands via the query interface to toggle on and off by looks of it.
https://weblogs.sqlteam.com/dang/2007/10/20/use-caution-with-explicit-transactions-in-stored-procedures/
Thanks, it's a long read. I'll update you when get some insights