SQL Query not working on Project database

[Felicity]

Hi All,

In SQL Query Analyzer, I'm running the following script to delete cancelled
tasks from the project server database:

select ma.WASSN_ID, mp.PROJ_NAME, ma.TASK_NAME,mr.RES_NAME from
MSP_WEB_ASSIGNMENTS ma
join MSP_WEB_PROJECTS mp
ON ma.WPROJ_ID = mp.WPROJ_ID
join MSP_WEB_RESOURCES mr
ON ma.WRES_ID = mr.WRES_ID
where
ma.WASSN_DELETED_IN_PROJ <>0
order by 1

But I keep getting an error that says MSP_WEB_ASSIGNMENTS, MSP_WEB_PROJECTS
and MSP_WEB_RESOURCES are invalid object names. I verified the tables are
indeed in the database.

Does anyone know why it says they're invalid object names? I'm using a
Project Server administrator account to perform this query so I don't think
it's a permissions issue.

 

[Rami]

Hi

There is a combo box at the top that points to the database. Are you sure
that you are pointing to Project Server Database?

 

[Felicity]

Hi Rami,

That was the problem. I didn't see that box up there. The script worked
wonderfully now. Thanks so much for your help.

Felicity

 

[Felicity]

Hi Rami,

I guess I spoke too soon. Although the script did run successfully, it not
only showed the cancelled tasks, but also it's showing completed tasks. I
thought this script would show only the cancelled tasks.

Do you know why it's showing completed tasks as well?

Felicity