idempotent-enable-snapshot-iso.sql

# Note: technically snapshot isolation can be in a 'pending' state
# In this state it is waiting for open transactions to complete before the setting turns on
# This script does not check for that state, it simply looks to see if it's off and enables it in that case

IF
(
    SELECT snapshot_isolation_state_desc
    FROM sys.databases
    WHERE database_id = DB_ID()
) = 'OFF'
BEGIN
    PRINT 'Enabling snapshot isolation...';
    ALTER DATABASE CURRENT SET ALLOW_SNAPSHOT_ISOLATION ON;
END;
ELSE
    PRINT 'Snapshot isolation not set to off, moving on...';