Check Current Isolation Level

        To check the Current Isolation Level, execute the below script :

Reference: Govind Badkur(http://sqlserver20.blogspot.com)