Snapshot isolation must be enabled by setting the ALLOW_SNAPSHOT_ISOLATION ON database option before it is used in transactions. You must enable snapshot isolation in each database that uses it with the Transact-SQL ALTER DATABASE statement. In this respect, snapshot isolation differs from the traditional isolation levels of READ COMMITTED, REPEATABLE READ, SERIALIZABLE, and READ UNCOMMITTED, which require no configuration.
...
| No Format | ||
|---|---|---|
| ||
select name, snapshot_isolation_state_desc, is_read_committed_snapshot_on from sys.databases |
| Info |
|---|
For avoiding lock in parallel sessions, table have to be created with ALLOW_PAGE_LOCKS = OFF option. |