You are here:Home » tsql » Isolation level settings at database level

Isolation level settings at database level

/************************************************************************
Set the Read committed snapshot option ON
*************************************************************************/
ALTER DATABASE TEST SET READ_COMMITTED_SNAPSHOT ON;
GO


/************************************************************************
*************************************************************************/
select is_read_committed_snapshot_on
from sys.databases