Skowronek

Posts Tagged ‘SQL Server’

AceProject Max User Account Delimma

AddThis Social Bookmark Button

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

Verio Offering Free Web Hosting

AddThis Social Bookmark Button

On one of the Windows Live sites we visited today there was an add from Verio offering free Microsoft web hosting until January 2010 (around 2 years). Perfect to test some of these hosted Windows solutions.

Free Windows Hosting with Verio.