Unable to Set/Alter Isolation Level in Microsoft SQL Server - Stuck "Executing" in Server Management Studio (Doc ID 971755.1)

Last updated on JUNE 30, 2016

Applies to:

Primavera P6 Professional Project Management - Version 6.0 to 7.0 [Release 6.0 to 7.0]
Primavera P6 Enterprise Project Portfolio Management - Version 6.0 to 7.0 [Release 6.0 to 7.0]
Information in this document applies to any platform.

Symptoms

When upgrading database to P6v7, one required step is to change the isolation level of the database to "read committed snapshot" by issuing the command (see P6v7 Administration Guide P.293):

alter database <database name> set read_committed_snapshot on

After submitting the alter command, SQL Server Management Studio reports that it is "executing" but the command does not complete.


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms