Enable snapshot isolation

• California

  SSCommitted

  Points: 1888

  More actions

  May 7, 2009 at 12:58 am

  #131226

  will these commands enable snapshot isolation on my prod database?

  ALTER DATABASE Prod SET READ_COMMITTED_SNAPSHOT ON

  ALTER DATABASE Prod SET ALLOW_SNAPSHOT_ISOLATION ON

  Once enabled, is there a way to see, what isolation mode my database running?

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  May 7, 2009 at 5:04 am

  #990225

  Once enabled, is there a way to see, what isolation mode my database running?

  select [name], is_read_committed_snapshot_on,

  snapshot_isolation_state, snapshot_isolation_state_desc

  from sys.databases;