MS Project 2007 :: Corrupted Tasks

How do you know if your Project has a corrupted tasks, simply the following indicators will till you if so

1. One ore more of your resource report that his "My Taks" is showing sharepoint error message
   
2. If you know how to query your database (Published DB of your server) and get unfortunately one row at lease
   

   SELECT MSP_PROJECTS.PROJ_NAME, MSP_ASSIGNMENTS_SAVED.TASK_NAME,
   MSP_RESOURCES.RES_NAME, MSP_ASSIGNMENTS_SAVED.ASSN_UID,
   MSP_ASSIGNMENTS_SAVED.PROJ_UID,
   MSP_ASSIGNMENTS_SAVED.TASK_UID, MSP_ASSIGNMENTS_SAVED.RES_UID
   FROM MSP_ASSIGNMENTS_SAVED INNER JOIN
   MSP_PROJECTS ON MSP_ASSIGNMENTS_SAVED.PROJ_UID =
   MSP_PROJECTS.PROJ_UID INNER JOIN
   MSP_RESOURCES ON MSP_ASSIGNMENTS_SAVED.RES_UID =
   MSP_RESOURCES.RES_UID
   WHERE (NOT EXISTS
   (SELECT TASK_UID
   FROM MSP_TASKS_SAVED
   WHERE (TASK_UID =
   MSP_ASSIGNMENTS_SAVED.TASK_UID)))

    

   Then to resolve this issue do the following

• Open Gantt View, Insert "Publish" column, and select No for the task that you got from the above query
• Publish your project
• Again Gantt View, For the  "Publish" column, and select "Yes" for the task that you got from the above query
• Publish you project

Best Regards

Bilal Okour