Re: Way to mass remove the deleted (X tasks) in the PWA side?
From: Christophe Fiessinger [MS] (chrisfie_at_online.microsoft.com)
Date: 10/19/04
- Next message: Dale: "Closing a Project"
- Previous message: Christophe Fiessinger [MS]: "Re: Cannot connect to OLAP Server."
- In reply to: Sandy: "Way to mass remove the deleted (X tasks) in the PWA side?"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 19 Oct 2004 23:20:19 +0200
Sandy,
You can setup a scheduled job in SQL server to execute the following T-SQL
command:
Update From MSP_WEB_ASSIGNMENTS
Set WASSN_REMOVED_BY_RESOURCE = 1
Where WASSN_DELETED_IN_PROJ = 1
Regards,
CF.
"Sandy" <Sandy@discussions.microsoft.com> wrote in message
news:18CF9F85-246D-4FD0-B056-AB65A1329F52@microsoft.com...
> Short of clicking on each task, and then clicking on Hide, is there a way
to
> remove them all at once?
- Next message: Dale: "Closing a Project"
- Previous message: Christophe Fiessinger [MS]: "Re: Cannot connect to OLAP Server."
- In reply to: Sandy: "Way to mass remove the deleted (X tasks) in the PWA side?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|