CODEWITHSUNDEEP
sqlsql-server
Cshah
Cshah

Reputation: 251

Read Committed Snapshot

Once you alter database to use Read Commited Snapshot isolation level, OR snapshot isolation level

Do all transaction now uses that isolation as default or Read Commited is stil the default isolation level and you have to change all stored proc to use by specifying

SET TRANSACTION ISOLATION LEVEL Read_committed_snapshot to use Read Committed Snapshot

Upvotes: 2

Views: 425

Answers (1)

gbn
gbn

Reputation: 432431

The entire database and code and transaction all use whatever your setting us

Unless you set SET TRANSACTION ISOLATION LEVEL in the code somewhere separately...

Upvotes: 2

Related Questions