Current option value

• serhiy

  Grasshopper

  Points: 17

  More actions

  October 24, 2001 at 5:54 pm

  #58001

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

  Thanks,

  Serhiy

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  October 24, 2001 at 6:40 pm

  #419302

  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

  Andy
  Connect with me on LinkedIn