Current option value

  • Could you please suggest how could I check current XACT_ABORT option vavue?

    Thanks,

    Serhiy

  • 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 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply