node-sqlserver-v8 icon indicating copy to clipboard operation
node-sqlserver-v8 copied to clipboard

Can't find docs aboout transaction XACT_ABORT

Open Doc999tor opened this issue 6 years ago • 3 comments

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

Doc999tor avatar Aug 10 '19 16:08 Doc999tor

Anyone?

Doc999tor avatar Aug 25 '19 23:08 Doc999tor

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/

TimelordUK avatar Aug 26 '19 16:08 TimelordUK

Thanks, it's a long read. I'll update you when get some insights

Doc999tor avatar Aug 29 '19 12:08 Doc999tor