Transtion

Question

Which of these is the default setting of sql server Read Committed with snapshot or Read Committed with Locks?

Vulpes · Answer

The default is Read Committed with Locks. If you want Read Committed with Snapshot you have to turn it on: ALTER DATABASE SET READ_COMMITTED_SNAPSHOT ON;