Deletion of Resources in Enterprise Resource Pool

[SteveR]

Is anybody aware of a routine that allows the deletion of
resources from the Enterprise Resource Pool? We are in a
situation where some of our resources have left the
company or have moved to different departments.

 

[Dale Howard [MVP]]

SteveR --

If you are using Project Server 2002, you can permanently delete a resource
using the SQL script referenced in the following link:

http://www.projectserverexperts.com/Project Server FAQs/deleteresource.htm

If you are using Project Server 2003, you can delete the resource in the
Clean up Project Server database section of PWA. Hope this helps.

 

[Karen A]

Mr. Howard,

The URL that you provided is no longer valid. Would you please update it
as the code is of interest to me.

Thanks,

Karen

 

[Don]

Dale, I have 85 resources to delete. The Clean Up Project Server Database
functionality of PWA allows you to delete one at a time? Am I missing
something? Thanks.

 

[Dale Howard [MVP]]

Don --

If you are using Project Server 2003, you should use the Project Server
Cleaner Tool to do a mass deletion of resources. Download it at:

http://www.microsoft.com/downloads/...a4-ada5-4aa7-ad98-2e7681d69beb&DisplayLang=en

Hope this helps.