Check the Isolation Level with DBCC useroptions
Recently I was asked by a Microsoft Dynamics AX consultant “Can you tell me what is the isolation level for this database?”. Sure I can 🙂
You can run the DBCC UserOptions command on any database to get information about its language, dateformat, datefirst as well isolation level.
Set Option Value
isolation level read committed