How to delete administrative assignment

[Newbie]

Hello,

An administrative task has been deleted in the Administrative project. How
is it possible to delete all the assignments which remain on this task in
the timesheets?

Thanks

 

[Gaurav Wason]

If you want to hide all the deleted task from project server here is what I
am using. Please test this query in your development environment first

UPDATE MSP_WEB_ASSIGNMENTS
SET WASSN_REMOVED_BY_RESOURCE = 1
WHERE WASSN_Deleted_In_Proj = 1
and task_is_Summary = 0
and WASSN_REMOVED_BY_RESOURCE = 0

Let me know if this helps.