Configuring the Microsoft SQL Server Database

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

Open Microsoft SQL Server Management Studio.
Open a new query window for the updated database and run the following command:
dbcc useroptions
Look for isolation level in the Set Option column and verify that the value is set to read committed snapshot.
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.
Run 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 P6 Professional Version 20.