Thursday, October 25, 2012

SET TRANSACTION ISOLATION LEVEL (Transact-SQL)


ALTER DATABASE SET READ_COMMITTED_SNAPSHOT ON;


SELECT name ,is_read_committed_snapshot_on FROM
sys.databases WHERE is_read_committed_snapshot_on=1