Fixing corrupted assignments

[Bilal]

Hi
I am runing Microsoft Project Server 2007 with SP1, Sql 2000
I have a proplem with one project and it is that when saving from Project
pro an error with code 12000 get raised
I used one tool to get the corrupted tasks (assignments that has no tasks)
and it listed the corrupted assignments
I ran a query that shows that the tasks for these assignments are really not
there in MSP_Tasks table
My Questions are
1- How can I insert the right tasks for those assignments from the database
end
2- Is there any person who can help me understanding the table sturcure of
both Tasks and Assginments, to be more specific, what and when the Project
Server use the followqing tables
- MSP_Assgignments, MSP_Assgignments_Saved
- MSP_Tasks, MSP_Tasks_Saved


Now, how can

 

[Rod Gill]

The draft and published dbs have no schema published for them as Microsoft
has reserved the right to change the schema as needed in a hotfix or SP. The
only supported ways to add tasks programmatically is via PSI and Project
VBA.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com