4 Replies Latest reply on Mar 25, 2013 6:46 AM by Bill Robinson

    Is it necessary to execute new query?

    Team Fujitsu

      The section "installing" in an online manual from 8.2 SP4 has the following description.
      To reduce the likelihood of database deadlocks, perform the following steps:
      Right-click the database server node and select New Query.
         Execute the following query:
         ALTER DATABASE <db_name> SET ALLOW_SNAPSHOT_ISOLATION ON;
         Execute the following additional query:
         ALTER DATABASE <db_name> SET READ_COMMITTED_SNAPSHOT ON;

       

      But,the section "installing" in older 8.2 SP1 manual has only following desctipion.
         Execute the following additional query:
         ALTER DATABASE <db_name> SET READ_COMMITTED_SNAPSHOT ON;

       

      Is it necessary to execute new query,i.e.ALLOW_SNAPSHOT_ISOLATION,when upgrading from 8.2SP1 to 8.2SP4 ?

       

      BladeLogic:BMC BladeLogic Server Automation 8.2 SP1 -> 8.2 SP4.

      OS:Windows server 2008 R2

      DB:MS SQL server 2008