Following SQL Code-snippet will helps to find out What is the Isolation Level is configured for Current Database,

SELECT CASEtransaction_isolation_level

      WHEN 0 THEN’Unspecified’
      WHEN 1 THEN’ReadUncomitted’
      WHEN 2 THEN’Readcomitted’
      WHEN 3 THEN’Repeatable’
      WHEN 4 THEN’Serializable’
      WHEN 5 THEN ‘Snapshot’ END ASTRANSACTION_ISOLATION_LEVEL
FROM
      sys.dm_exec_sessions
where session_id = @@SPID
The above query will return the Isolation of of current DB. There are many ways to find out this settings.
You can find it out by using DBCC command as well,
DBCC USEROPTIONS
After execute the given DBCC Command, look at the value of “isolation level” in the result, refer the exhibit given below:-
Categories: SQL

Related Posts

SQL

SQL – Get Procedure/Function/Trigger Name

Problem: When I write any procedure for UI functionality, I may require to throw the Procedure Name to UI if any error occurs, This will help people to identify/Isolate the bug if occured Also I Read more…

SQL

Cannot login to SSAS 2008 from SSMS?

Issue: When I tried to connect to a named instance of SQL Server 2008 Analysis Services (SSAS) by using SQL Server Management Studio, I received the following error message intermittently:

SQL

How To: Lists Linked Server

The following Stored procedure will returns the list of linked servers defined in the server in which we are executing it. sp_linkedservers This procedure will return the following informations about the linked server Column name Read more…