gipasoft

Check and Update Transaction Isolation Lebel

Apr 2nd, 2020
826
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.33 KB | None | 0 0
  1. SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
  2.  
  3. SELECT session_id, CASE transaction_isolation_level
  4. WHEN 0 THEN 'Unspecified'
  5. WHEN 1 THEN 'ReadUncommitted'
  6. WHEN 2 THEN 'ReadCommitted'
  7. WHEN 3 THEN 'Repeatable'
  8. WHEN 4 THEN 'Serializable'
  9. WHEN 5 THEN 'Snapshot' END AS TRANSACTION_ISOLATION_LEVEL
  10. FROM sys.dm_exec_sessions
Advertisement
Add Comment
Please, Sign In to add comment