J
Jimmy
I am looking for a way to clean up completed tasks from the Project
Server database. If I log onto the PWA as administrator and go to the
Admin section and select 'Clean Up Project Server Database' and then
select the tasks option I receive a message confirming that the
selected tasks have been deleted. However, when I view the tasks in the
PWA they have not been deleted. Also, the amount of rows in msp_tasks
table does not change. I have also ran SQL Profiler while running the
command and the only SQL that is run against the database when I try to
delete rows through the PWA is the "Set No_Browsetable on". This is
consistent regardless of which options I choose for which tasks to
delete (e.g. all tasks, only complete tasks, tasks for specific
resource). Has anyone else had this problem or is there something I am
not understanding about how the function is supposed to work? Any help
with this would be appreciatted.
Server database. If I log onto the PWA as administrator and go to the
Admin section and select 'Clean Up Project Server Database' and then
select the tasks option I receive a message confirming that the
selected tasks have been deleted. However, when I view the tasks in the
PWA they have not been deleted. Also, the amount of rows in msp_tasks
table does not change. I have also ran SQL Profiler while running the
command and the only SQL that is run against the database when I try to
delete rows through the PWA is the "Set No_Browsetable on". This is
consistent regardless of which options I choose for which tasks to
delete (e.g. all tasks, only complete tasks, tasks for specific
resource). Has anyone else had this problem or is there something I am
not understanding about how the function is supposed to work? Any help
with this would be appreciatted.