MS Project Server 2003 - Project Rename Script - Part 3
Please read Part 1, prior to read this section.
Please read Part 2, prior to read this section.
Project Rename by executing SQL Stored Procedure:
Suppose, you have a project plan called “EPM Central Deployment.published” in project server. You want to rename this project plan to “EPM Central Implementation”.
The following steps required to rename the project plan.
1 Find the PROJ_ID for this project from table “MSP_PROJECTS” by running the following query on SQL Query Analyzer.
SELECT PROJ_ID,PROJ_NAME FROM
dbo.MSP_PROEJCTS
WHERE PROJ_NAME = ‘EPM Central Deployment.published’
Please note the PROJ_ID from above query.
2 Let’s say, PROJ_ID for EPM Central Deployment.published is 512; The syntax to execute the stored procedure is
EXEC storedprocedulename Proj_ID, New name, 0
Please don't specify .Published with new name. This procedure automatically append .published with new name.
Where 0 Is initial error code. If Project has been checked out, you will get the return code as -2; If rename suceess, you will get 0 as return code.
You have to run the following command to rename the plan.
EXEC dbo._sp_ProjRename 512, ‘EPM Central Implementation’, 0
| |
