Oracle Primavera - PM6 Member for 16 years 3 months Member for 16 years 3 months Submitted by Zoltan Palffy on Thu, 2025-05-22 17:40 Permalink it appears that your session it appears that your session is timing out run this scritp in sql 1. Launch the SQL Server Management Studio, select SQL Server Authentication, and connect as the schema owner (default sa). 2. On the left expand Databases. 3. Right-click the P6 database name and choose New Query from the pop-up menu. Paste the following script in the query window and click Execute: ALTER DATABASE SCOPED CONFIGURATION SET LEGACY_CARDINALITY_ESTIMATION = ON ; 5 Execute the following query to confirm the setting has been updated: select name, value from sys.database_scoped_configurations where name like 'LEGACY_CARDINALITY_ESTIMATION' The result should indicate that 'LEGACY_CARDINALITY_ESTIMATION' now has a value of '1'. Log in or register to post comments
Member for 16 years 3 months Member for 16 years 3 months Submitted by Zoltan Palffy on Thu, 2025-05-22 17:40 Permalink it appears that your session it appears that your session is timing out run this scritp in sql 1. Launch the SQL Server Management Studio, select SQL Server Authentication, and connect as the schema owner (default sa). 2. On the left expand Databases. 3. Right-click the P6 database name and choose New Query from the pop-up menu. Paste the following script in the query window and click Execute: ALTER DATABASE SCOPED CONFIGURATION SET LEGACY_CARDINALITY_ESTIMATION = ON ; 5 Execute the following query to confirm the setting has been updated: select name, value from sys.database_scoped_configurations where name like 'LEGACY_CARDINALITY_ESTIMATION' The result should indicate that 'LEGACY_CARDINALITY_ESTIMATION' now has a value of '1'.
Member for
16 years 3 monthsit appears that your session
it appears that your session is timing out
run this scritp in sql
1. Launch the SQL Server Management Studio, select SQL Server Authentication, and connect as the schema owner (default sa).
2. On the left expand Databases.
3. Right-click the P6 database name and choose New Query from the pop-up menu.
Paste the following script in the query window and click Execute:
ALTER DATABASE SCOPED CONFIGURATION SET LEGACY_CARDINALITY_ESTIMATION = ON ;
5 Execute the following query to confirm the setting has been updated:
select name, value from sys.database_scoped_configurations where name like 'LEGACY_CARDINALITY_ESTIMATION'
The result should indicate that 'LEGACY_CARDINALITY_ESTIMATION' now has a value of '1'.