Permanently Delete Resources

J

James

Hi,

Can anyone supply a SQL script to permanently delete a resource in a Project
Server 2003 database?

I have got the PSCleaner utility from the M$ website, but there are so many
resources in the database (6000+) that it crashes when I try to delete them.

Any suggestions?

James
 
E

Ed Morrison

James,
Try looking at the dbo.MSP_PDS_ResourceDelete stored procedure. Its in the
Project Server database.

Hope this helps.
 
Top