Determining Isolation Level

• Ken Davis

  SSCarpal Tunnel

  Points: 4329

  More actions

  August 30, 2010 at 10:44 am

  #141773

  I have executed the following to change a SQL 2005 database's isolation level and now I want to confirm the setting.

  ALTER DATABASE contentdb

  SET READ_COMMITTED_SNAPSHOT ON;

  GO

  But I can't figure out how to display the database's current isolation level setting.

  thanks for any guidance...

• Ken Davis

  SSCarpal Tunnel

  Points: 4329

  More actions

  August 30, 2010 at 10:47 am

  #1213837

  Never mind. I found the answer immediately after posting my message.

  DBCC USEROPTIONS

  thanks