How to see what a SQL Server instance''s Transaction Isolation level is?

• Martin-327112

  Grasshopper

  Points: 17

  More actions

  June 29, 2006 at 12:48 pm

  #118529

  Hi guys,

  Forgive the simple (perhaps, (not a DBA)) question but could you tell me how can I see what's the current setting re: Transaction Isolation Level of my server?

  Thanks,

  Martin.

• Bhushan

  Default port

  Points: 1427

  More actions

  June 29, 2006 at 2:54 pm

  #646850

  dbcc useroptions and lookfor SetOption = 'isolation level'

• sqlemail@yahoo.com

  SSC Eights!

  Points: 919

  More actions

  July 6, 2006 at 3:07 am

  #647692

  This is what i get, may be I'm missing something. Any help?

   

  dbcc useroptions

  Set Option                    Value     

  -----------------------------------------

  textsize                      64512

  language                      us_english

  dateformat                    mdy

  datefirst                     7

  quoted_identifier             SET

  arithabort                    SET

  ansi_null_dflt_on             SET

  ansi_defaults                 SET

  ansi_warnings                 SET

  ansi_padding                  SET

  ansi_nulls                    SET

  concat_null_yields_null       SET

  (12 row(s) affected)

   

  
  paul