Publishing -- Changing Respondent

[PG]

Our PMO wants to publish all projects themselves but have approvals for time
card done by the manager. We want to use some sql to force back the approver
to the project manager after doing all the publishing. Where in the DB is the
field we need to change back?

 

[Dale Howard [MVP]]

PG --

After the PMO has published the project, the project manager needs to take
over as the manager of the project. Refer to the following FAQ for the
steps:

http://www.projectserverexperts.com/Shared Documents/changeprojmgr.htm

Hope this helps.

 

[PG]

Thanks dale for the reference. I was aware of those constraints. What i was
looking for is the field in the project server database and the matching
flags that indicate who the current manager is. In this way we could just run
a script that would keep everything synchronized to the person to whom we
wish the responses to go. Any ideas. I have looked in the projdb.htm but it
is not quite clear which field and flag are needed.

THANKS.....

 

[Dale Howard [MVP]]

PG --

Since you want a database solution to your situation, you might want to post
your question on the microsoft.public.project.developer newsgroup. Hope
this helps.