Enterprise Global Unique Identifier

B

Bartolini

Can anyone answer the following;

Is there a unique number that corresponds to the Enterprise Global?
Does it change every time the EG is updated?
Where is it exactly (in SQL tables)?

Thanks,
Bartolini
 
G

Gary L. Chefetz \(MVP\)

Bartolini:

It's stored like any other project in MSP_PROJECTS and related tables. Hint,
use the database documentation on your server under the help files.

--

Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

-
 
B

Bartolini

Hi Gary-
I did look at that table.
I noticed that the number (2) does not change when I update the EG.
Is there any other unique identifier which changes when I update the EG?

~Bartolini
 
R

Richard

Bartolini,

Yeah the EG WILL change uids on you if the EG has some information added to
the EG and saved. In our case its when we add a new enterprise field to the
global template it will increment the enterprise global id. Easy enough to
get around in with sql by doing a simple select.

Email me @ [email protected] and tell me what you're doing and
maybe we can swap notes :) We are using Solomon with project server and the
integration while there, is a bit shabby. So we have been enhancing it with
a bunch of different procedures that writes directly to the project server
DB. Microsoft would prefer that you use XML with PDS to update project
server 2k3, but I don't know squat about XML yet. Learning but not good
enough yet. And what Gary said is true, Msoft either let it slip ( :) ) or
was being generous when they published the project servers Database scheme
with a decent descript of all the tables.
 
Top