October 24, 2001 at 5:54 pm
Could you please suggest how could I check current XACT_ABORT option vavue?
Thanks,
Serhiy
October 24, 2001 at 6:40 pm
You can run sp_configure 'user options' to return a bitmapped value. If you AND the value with 16384 I think that will tell if the bit is set or not. Search for 'user options Option' in BOL for more info. You could also disassemble sp_configure and maybe find a way to get it a little more directly. Overall, it's almost as easy to just set the value and not worry about what it is.
Andy
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy