Isolation Level

• sqldba-294117

  Hall of Fame

  Points: 3486

  More actions

  June 15, 2006 at 11:44 am

  #60505

  How i can check/know what is the setting of my server Isolation Level.i have already used "DBCC USEROPTIONS" & see no information about isolation level. Any help will be highly appreciated.

• sree-226516

  SSCrazy

  Points: 2590

  More actions

  June 15, 2006 at 11:54 am

  #644046

  If you see no information about isolation level when you execute DBCC USEROPTION that shows isolation level is default that is read commited.

   

  Thanks,

  SR

  Thanks,
  SR