P6.1 SQL error

Hi Leo,

From what you are explaining, it sounds like you are using SQL Server Management Studio to run the queries. Please advise if this is not the case.

When you run these queries you need to ensure that you have your P6 database selected. There are a couple of ways you can do this.

The first is to ensure that the drop down box at the top left of the screen has your p6 database selected. I'm assuming this is probably displaying 'master' for you. it should display something like 'PMDB' or 'pmdb$primavera'.

the second option is to specify a command as part of your query. eg. if your p6 database name in PMDB you might run the following:

use pmdb
update statistics project with fullscan ,all
update statistics task with fullscan, al

use pmdb
exec sp_updatestats

Please note that updating your database statistics is not a golden bullet. There may be other issues causing your p6 environment to perform slowly.

Regards,

Stevel

THANK YOU for taking the time to address my problem.  Your first option exactly addressed my problem.  Load time literally went from 30 minutes to about 30 seconds! 

I really appreciate your help.

Leo

It has been awhile, but I had to install P6.1 on a new laptop.  Windows 7 Pro 32bit.  It installed and runs ok, but when I try to run the SQL tweaks:

1st Query

update statistics project with fullscan ,all
update statistics task with fullscan, all

2nd Query
exec sp_updatestats

I get the following: