Breaking Resource Pool Links

[TomG]

Hi,
I have a SQL Server database containing a few hundred project files, some of
which are connected to a central resource pool.

I want to create an automated process that looks at each project that is
linked to the resource pool, and breaks the link if the sharer file does not
have any assignments more recent than one month ago.

First question - is this possible? Second question - is this possible to do
via the back end (i.e. can I just write some SQL to achieve my goal?). My gut
feeling is that the database tables do not hold ALL the Project information
and so the answer is going to be "no" (

Be grateful for any help on this one.

Regards,
Tom

 

[Rod Gill]

Hi,

Try creating a temporary database to experiment with. Updating projects in a
database can cause corruptions when you get it wrong!

In the MSP_Projects table look at PROJ_POOL_ATTACHED_TO and PROJ_IS_RES_POOL

Sort the Assignments table by finish date to read the latest date and maybe
only look at incomplete tasks?

Read carefully the pjdb.htm file to understand what flags you need to set to
tell Project you have updated something.