How to get Isolation Level of connection

• Brian Aborg Weje

  Valued Member

  Points: 62

  More actions

  September 29, 2020 at 10:00 am

  #3791547

  I need a way to see what Isolation Level a connection is using?

  I suspect a software vendor is using READ_UNCOMMITED, but I need to know.

  /Brian

• Ken McKelvey

  SSCoach

  Points: 18842

  More actions

  September 29, 2020 at 3:36 pm

  #3791684

  The transaction_isolation_level column in sys.dm_exec_sessions.