EPM Central Project Server Tutorials
Home Deployment    MS Project PWA SharePoint Articles Administrators FAQs Consulting Search Site Map
  Error Messages

Project Server 2003

PWA Login DropDown

Inactive vs. Delete

Actual Work Protected

  2003 SQL Queries

  Enterprise Fields
    Project Fields
    Resource Fields
    Sample Queries

Admin Tools

Re-associate Site

Project Archival

  VBA

 
 
 
Administration -> MS Project Server 2003 -> DB Scripts


Delete unprocessed task updates


The following SQL query deletes the pending messages (task updates) not approved by PM for specific project.


How to Run: Run the following query on SQL Query Analyzer, by selecting Project Server database.

***********************************************************************************

Step 1: Find the WPROJ_ID for project

Specify your project name in WHERE clause. EPM Central Office Move is the project name in my example.

SELECT WPROJ_ID FROM MSP_WEB_PROJECTS
WHERE WPROJ_NAME LIKE '%EPM Central Office Move%'


Step 2: Delete pending task updates

Specify the WPROJ_ID in below query; Let's say WPROJ_ID is 128

DELETE FROM MSP_WEB_ASSIGNMENTS
WHERE WASSN_ID IN
(SELECT MSP_WEB_ASSIGNMENTS.WASSN_ID
FROM MSP_WEB_ASSIGNMENTS INNER JOIN
MSP_WEB_PROJECTS ON MSP_WEB_ASSIGNMENTS.WPROJ_ID = MSP_WEB_PROJECTS.WPROJ_ID INNER JOIN
MSP_WEB_RESOURCES ON MSP_WEB_ASSIGNMENTS.WRES_ID = MSP_WEB_RESOURCES.WRES_ID INNER JOIN
MSP_WEB_RESOURCES MSP_WEB_RESOURCES_1 ON MSP_WEB_PROJECTS.WRES_ID =
MSP_WEB_RESOURCES_1.WRES_ID INNER JOIN
MSP_WEB_RESOURCES MSP_WEB_RESOURCES_2 ON
MSP_WEB_ASSIGNMENTS.WRES_ID_MGR = MSP_WEB_RESOURCES_2.WRES_ID
WHERE (MSP_WEB_ASSIGNMENTS.WASSN_SEND_UPDATE_NEEDED = 1) AND
(MSP_WEB_ASSIGNMENTS.WASSN_ACTUALS_PENDING = 1) AND
(MSP_WEB_ASSIGNMENTS.WASSN_UPDATE_STATUS = 1) AND
(MSP_WEB_ASSIGNMENTS.WASSN_SEND_UPDATE_DATE IS NOT NULL)
AND MSP_WEB_PROJECTS.WPROJ_ID = 128)



***********************************************************************************



Copyright 2013. EPM Central. All rights reserved.