Read Committed with snapshot or Read Committed with Locks?
Transtion
Which of these is the default setting of sql server
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
VulpesPosted May 8, 2013, 11:32 AM
If you want Read Committed with Snapshot, you have to turn it on:
ALTER DATABASE