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 -> SQL Queries
Projects with no WSS Sites

The following query displays list of the projects which are not associated with SharePoint sites.

Note:The projects which are associated with SharePoint site will have WPROJ_ID value on WPROJ_DEFAULT_WPROJ_ID Column.

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

SELECT WPROJ_ID, PROJ_NAME, WPROJ_DEFAULT_WPROJ_ID,
WPROJ_STS_SUBWEB_NAME
FROM MSP_WEB_PROJECTS
WHERE (WPROJ_STS_SUBWEB_NAME='NONE' OR WSTS_SERVER_ID=0 )
AND WPROJ_DEFAULT_WPROJ_ID=WPROJ_ID
ORDER BY PROJ_NAME



Copyright 2013. EPM Central. All rights reserved.