System databases Isolation

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

Thanks for the question.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Ed Wagner SSC Guru Points: 287026 More actions · Answer 2

Stewart "Arturius" Campbell (9/20/2016)
Excellent question, Tom, thanks
Had to read up to make sure, so learned something today.

I did too. Thanks for a good question.

George Vobr SSCrazy Eights Points: 9996 More actions · Answer 3

Formulation of the question makes me a bit confused. Which transaction isolation level is NOT available to transactions running

in the master and msdb databases? For the DB administrator, all responses in today's Qotd are available.

However, for the average user may be not available READ_COMMITTED_SNAPSHOT isolation level.

Thanks Tom for this interesting question. Well put together QotD is usually more difficult than to answer it.;-)

Detailed information about the master Database options eg. ALLOW_SNAPSHOT_ISOLATION

or READ_COMMITTED_SNAPSHOT etc. can be found here:

RohitK25 SSC Enthusiast Points: 198 More actions · Answer 4

SSC Enthusiast

Points: 198

September 20, 2016 at 11:37 pm

good question

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 5

SSC Guru

Points: 76202

September 21, 2016 at 6:32 am

Nice question