How to detect READ_COMMITTED_SNAPSHOT is enabled?

October 26, 2022 by Tarik

SELECT is_read_committed_snapshot_on FROM sys.databases 
WHERE name="YourDatabase"

Return value:

1: READ_COMMITTED_SNAPSHOT option is ON. Read operations under the READ COMMITTED isolation level are based on snapshot scans and do not acquire locks.
0 (default): READ_COMMITTED_SNAPSHOT option is OFF. Read operations under the READ COMMITTED isolation level use Shared (S) locks.