Aan de slagGa gratis aan de slag

Setting READ COMMITTED SNAPSHOT to ON

The default isolation level of your database is READ COMMITTED. You made some scripts that were supposed to be run under the READ COMMITTED isolation level.

Now, you want every script you already made to be run with the READ COMMITTED SNAPSHOT option set to ON. In doing this, each statement under the READ COMMITTED isolation level will see the committed changes that occur before the start of each statement.

Which options do you need to set in your database?

Deze oefening maakt deel uit van de cursus

Transactions and Error Handling in SQL Server

Cursus bekijken

Praktische interactieve oefening

Zet theorie om in actie met een van onze interactieve oefeningen.

Begin met trainen