RBS Field

K

Kathy S

Does anyone know which table the RBS data is stored in in MSP 2003
Project Server? I need a SQL query which will refer to data from the
RBS field for resources.

Thanks,
Kathy
 
G

Gérard Ducouret

Kathy,

In the Project Server 2003 database you will find the table:
MSP_VIEW_RES_ENT with the fields :
- ResourceEnterpriseOutlineCode30ID
- ENT_ResourceUniqueID
In the MSP_WEB_RESOUCES table you will find the fields:
-WRES_ID
- RES_NAME
- WRES_RBS_UID

Hope this helps,

Gérard Ducouret
 
K

Kathy S

Kathy,

In the Project Server 2003 database you will find the table:
MSP_VIEW_RES_ENT with the fields :
 - ResourceEnterpriseOutlineCode30ID
 - ENT_ResourceUniqueID
In the MSP_WEB_RESOUCES table you will find the fields:
  -WRES_ID
 - RES_NAME
 - WRES_RBS_UID

Hope this helps,

Gérard Ducouret

"Kathy S" <[email protected]> a écrit dans le message de 942b3f63-7bf8-4660-910a-74c1f2df3...@p49g2000hsd.googlegroups.com...





- Show quoted text -
Click to expand...

Thank you for the information.
 
Top