Project Templates. Which table are they stored in?

[ScottC55]

Does anyone know which table the project templates are stored in? I can't
seem to find them anywhere.

Thanks!

 

[Dale Howard [MVP]]

ScottC55 --

How about MSP_PROJECTS? Hope this helps.

 

[ScottC55]

Yes, that's it. Do you happen to know what ID is used to link the project
name to the template?

 

[Dale Howard [MVP]]

ScottC55 --

I cannot determine where the Template information is stored in the
MS_PROJECTS table, or stored anywhere else for that matter. I know that you
can extract the information for each project using VBA with code such as
ActiveProject.Template, but I cannot see how to extract this information
from the SQL Server database. I would welcome comments about this from our
SQL Server gurus. Sorry I cannot be of more assistance.

 

[Gary L. Chefetz [MVP]]

Scott:

What do you mean by this question? The templates are stored as a project
type in the system. In all other regards, they're stored exactly the same
way any other projects are stored in the database.

 

[ScottC55]

I need to write a report that references which template was used for each
project. I suspect that each project has a template ID that it links to but
I can't seem to find which table / ID is used for this.

Thanks!

 

[Gary L. Chefetz [MVP]]

Scott:

If there's a field-level way to determine this in the database I'm not able
to think of it. I think it's easy enough to include this information in the
project itself.. I suggest setting up an Enterprise Project Outline Code for
this purpose. This way you get to use it in the Analyzer.

 

[ScottC55]

Yes - the outline code would do it. I was just hoping there was a way to do
it on the backend so that users don't have to specifiy this info for each
project.

Thanks for your help!

 

[Gary L. Chefetz [MVP]]

Scott:

You can default the value in the template. You can seed some information in
project properties. Run a macro that recognizes the template structure... A
few ideas to work with.