O
Omar
Hello All,
Where is the actual work done stored in the database
Which tables in the Project Server database do I need to clean up in
order to reset the project progress to 0%?
I have tried on a test database to delete all the entries which are
not scheduled without success.
delete from msp_web_work where wwork_type in (1,2)
More info:
We have just started a new financial year and had to clean up our
project server database. We have successfully deleted the old projects
and left the ongoing projects only. However, with these ongoing
projects, we want to delete all the actual work so that the project is
rest to 0% complete. As there are about 100 projects, it would not be
feasible to individually update one by one.
The reasons we want to do this are quite complex to explain here so I
hope you pardon me for that
Where is the actual work done stored in the database
Which tables in the Project Server database do I need to clean up in
order to reset the project progress to 0%?
I have tried on a test database to delete all the entries which are
not scheduled without success.
delete from msp_web_work where wwork_type in (1,2)
More info:
We have just started a new financial year and had to clean up our
project server database. We have successfully deleted the old projects
and left the ongoing projects only. However, with these ongoing
projects, we want to delete all the actual work so that the project is
rest to 0% complete. As there are about 100 projects, it would not be
feasible to individually update one by one.
The reasons we want to do this are quite complex to explain here so I
hope you pardon me for that