Problem getting duplicated resources

M

Magnus S

We have Windows Server 2003
MS Project Server 2003
MS Project Professional 2003

MS Project Server is set up as Enterprise Server but we havn't started to
use Enterprise resources

When we check in a Project the published project file gets duplicated
resources i,e, one resource has id 4 and is assigned task 3 and 4
When checked in I get another resource created with a new id because it
looks like MS Project server duplicates the resource...

Anyone seen this. A bug or are we doing something wrong,...

select R.PROJ_ID, ISNULL(R.RES_NAME,'') AS RES_NAME,
ISNULL(R.RES_INITIALS,'') AS RES_INITIALS ,R.RES_ID from MSP_RESOURCES R,
MSP_WEB_PROJECTS W where
R.PROJ_ID=W.PROJ_ID and W.WPROJ_ID= 116
and RES_NAME IS NOT NULL
ORDER BY RES_NAME

Regards
Magnus Salgo
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top