June 30, 2016 at 12:05 pm
Evening All,
Is it possble to set XACT_ABORT ON for an entire server or database on a server
I have a legacy app that we cannot change/alter/modify/recompile and its leaving sessions open indefinitely if there is an error.
Or is there a better way of handling this rather than using XACT abort if i cannot alter the application at all
Cheers
Alex
June 30, 2016 at 2:42 pm
Just to add - as it stands, I've resorted to killing off any SLEEPING sessions, after business hours, and if the session is > 2 hours old. Business hours stop at 7pm, and I run this at 10pm.
It's not an ideal or clean solution but am lacking an alternative.... Hence asking on here 🙂
Cheers All
Alex
July 1, 2016 at 3:09 am
https://msdn.microsoft.com/en-us/library/ms190763.aspx
suggests that you can set a global default (but the default will be overridden by an explicit SET in a query).
Chris
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply