Configuring the snapshot feature for Microsoft SQL Server

The snapshot feature in Microsoft SQL Server allows you to view a read-only copy of the database even when it is locked. Configuring the snapshot feature can also reduce deadlocks. To enable the snap shot feature, enter the following command: ALTER DATABASE db_name SET READ_COMMITTED_SNAPSHOT ON;