Check and Set Isolation level in SQL Server

Check isolation level：

DBCC useroptions

Default Isolation level in SQL Server is "READ COMMITTED", Once you want to change it:

For example, Set isolation level to READ UNCOMMITTED：

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED