Permanently Delete Resources

[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

 

[Ed Morrison]

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

Hope this helps.