Posts Tagged ‘SQL Server’
AceProject Max User Account Delimma
Thursday, March 13th, 2008
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.
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.
Verio Offering Free Web Hosting
Friday, February 22nd, 2008
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.
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.