Configuring the Microsoft SQL Server Database

Previous TopicNext TopicContents

To verify that the isolation level setting on the upgraded database has been set to "read committed snapshot":

  1. Open Microsoft SQL Server Management Studio.
  2. Open a new query window for the updated database and execute the following command:

    dbcc useroptions

  3. Look for isolation level in the Set Option column and verify that the value is set to read committed snapshot.
  4. If the value is read committed snapshot, you do not need to do anything. If the value is set to read committed, proceed to step 5.

    Caution: Only the connection executing the alter database command is allowed in the database. You must close all connections in the database until the execution of the command finishes.

  5. Execute the following command to fix the isolation level setting:

    alter database database name set read_committed_snapshot on

    Your database is now ready to use with R8.4.

Related Topics

About the P6 EPPM Configuration Wizard

Configuring Your Database

Configuring Your WebLogic Server with P6 EPPM

Connecting Applications to P6 EPPM

Completing Your P6 EPPM Installation



Legal Notices
Copyright © 1999, 2015, Oracle and/or its affiliates. All rights reserved.

Last Published Wednesday, July 29, 2015

PDF Library