Where is External Task Link information stored in SQL?

J

Jett Anderson

I'm working on a job where I had to rename a large number of existing
projects stored in MSP_* tables in SQL Server. I renamed the projects in the
MSP_PROJECTS!Proj_Name field and that went fine. But many of the projects had
externally linked tasks, and the references to those external projects have
been broken (no doubt because there names were changed!).

Does anyone know where I can find (to update) the name or id of a project
that is used as the source for an external task link, in the SQL Server
tables? I would have thought there would have been a field in MSP_TASKS or
MSP_LINKS that pointed to it, but haven't been able to find anything. Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Where is External Task Link information stored in SQL? 0
Location of externally linked project identifier in sql tables? 1
Cross-Project Task Links in Project Server 2007 0
PS2007: Gray Task in Cross Linked Project - Not Consistent 7
Cannot link to SQL server 17
Master Projects and External Dependencies with Subprojects 4
external task field in database 3
Where is 'baseline last saved date' stored in Project Server 2003? 1

Top