H
Hung
Hi,
I used to query against Project Server database (running SQLServer 2005) for
some tasks information without problem.
Just recently, the saved queries didn't return as expected. It kepts waiting
for the data to be return.
I tried to identify the reason, by running a SQL Query Analyzer, and execute
a simple SQL command:
select count(*) from MSP_VIEW_PROJ_TASKS_STD;
or something similar on this table.
And the result never came back unless I canceled the query.
I have no clue what the problem is. Is there an index accidentally deleted
by some reasons?
Your advice on how I can proceed is really appreciated
I used to query against Project Server database (running SQLServer 2005) for
some tasks information without problem.
Just recently, the saved queries didn't return as expected. It kepts waiting
for the data to be return.
I tried to identify the reason, by running a SQL Query Analyzer, and execute
a simple SQL command:
select count(*) from MSP_VIEW_PROJ_TASKS_STD;
or something similar on this table.
And the result never came back unless I canceled the query.
I have no clue what the problem is. Is there an index accidentally deleted
by some reasons?
Your advice on how I can proceed is really appreciated