Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
- SELECT session_id, CASE transaction_isolation_level
- WHEN 0 THEN 'Unspecified'
- WHEN 1 THEN 'ReadUncommitted'
- WHEN 2 THEN 'ReadCommitted'
- WHEN 3 THEN 'Repeatable'
- WHEN 4 THEN 'Serializable'
- WHEN 5 THEN 'Snapshot' END AS TRANSACTION_ISOLATION_LEVEL
- FROM sys.dm_exec_sessions
Advertisement
Add Comment
Please, Sign In to add comment