I think PDS lets you do this. However, Project Server 2007 has discarded PDS
(it simply wasn't up to the task) and replaced it with a new PSI interface.
You can change the tasks in the SQL DB but you will need to open the project
in Project Professional then save and re-publish to Project Server to update
PWA.