I have been using AceProject project management system for years. First at LANDesk, and now at McCann Erickson. Though it is a great tool for managing projects and tasks, it’s user management system lacks a vital feature, cascade delete user. That is, delete the user along with all it’s assigned tasks, projects etc.

So after having make various request for this “feature” I have written my own sequel procedure to handle the re-assignment and deletion of user accounts. In a nutshell, this procedure will re-assign all relevant data to a new user account, then delete the actual user record from the database. This then allows you to actually take advantage of your licenses (in our case 50 for now.)

Hopefully this helps someone else that is hosting this application as it did me.

Ace Project User Migration Stored Procedure