How to find current transaction level?

by

Run this:

SELECT 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 
where session_id = @@SPID

docs.microsoft.com reference for the constant values.

More Related Contents:

  1. Is it possible to write single query on two table which are not connected to each other?
  2. Insert an image in a column of a table that already has 5 columns
  3. How to avoid the “divide by zero” error in SQL?
  4. SET versus SELECT when assigning variables?
  5. Querying data by joining two tables in two database on different servers
  6. sql query to return differences between two tables
  7. Real life example, when to use OUTER / CROSS APPLY in SQL
  8. How to print VARCHAR(MAX) using Print Statement?
  9. Concatenate values based on ID
  10. Splitting delimited values in a SQL column into multiple rows
  11. EXISTS vs JOIN and use of EXISTS clause
  12. Restrict an SQL Server connection to a specific IP address
  13. Cumulative Total in MS Sql server [duplicate]
  14. How do I find the data directory for a SQL Server instance?
  15. Unpivot with column name
  16. How can I delete using INNER JOIN with SQL Server?
  17. Convert varchar into datetime in SQL Server
  18. Check if a row exists, otherwise insert
  19. Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql statement
  20. How to create table using select query in SQL Server?
  21. How do I group on continuous ranges
  22. Is it possible to perform multiple updates with a single UPDATE SQL statement?
  23. SQL SERVER: Get total days between two dates
  24. Incorrect syntax near the keyword ‘with’…previous statement must be terminated with a semicolon
  25. Store multiple bit values in a single table column
  26. SQL Server equivalent to MySQL enum data type?
  27. Using IF ELSE statement based on Count to execute different Insert statements
  28. SQL query to group by day
  29. Export table data from one SQL Server to another
  30. SQL, How to Concatenate results?

Leave a Comment