Project Server SQl and WSS SQL link

[Novica B]

I have been looking through the SQL tables for P.SVR and the WSS and con not
find the link.

I need to create a report bethween the two in access, importing tabels and
linking is no problem, i just can't find the unique link between the tables.

All i need is one unique identifer that will identify the project and it's
corresponding WSS site.

Can anyone help me.
Thanks
Novica B

 

[Ed Morrison]

Join the WSS full url from with the URL prefix & the project server web
project id. For example: web.FullUrl="sites/projectserver_" +
msp_web_projects.wproj_id. Several different tables in Sharepoint contain
the URL.