I want to clean up our blackpearl database (dev) after development is finished. When I used k2.net 2003 there was a stored procedure that was called wProcDelete that allowed me to specify the process and version to remove, and it would remove all instances and definitions for that process. And by extension, I could remove all processes of that name. The main benefit was that it would leave other processes alone. I have found a wipeall stored proc, but it just truncates all the tables, clearing out all versions and instances of all processes.

After development is finished I would have dozens of versions of the process cluttering up the db. With this stored proc I could remove all versions of the process, then go back to the project and redeploy. This would recreate the process as version 1. Any ideas? Would it be possible to modify the k2.net 2003 proc wProcDelete and create it for use with Blackpearl? (I know it would be possible, but how much modification would it need?)

Thanks