http://support.microsoft.com/kb/323330/
How to move the databases that are used by Windows SharePoint Services and by Project
Run this query against Project server database. select Res_UID, Res_name, Res_AD_Guid from msp_resources where Res_name
The following query lists the Project plans in Project Server 2003 which doesn’t have their
insert MSP_WEB_WORK_APPROVAL(WASSN_ID,WRES_ID,WPRD_START_DATE,WPRD_FINISH_DATE,WRES_ID_APPROVER,WAPPROVAL_STATUS,WAPPROVAL_NOTIFICATION_SENT)SELECT WASSN_ID,WRES_ID,WPRD_START_DATE,WPRD_FINISH_DATE,WRES_ID,1,0FROM MSP_WEB_ASSIGNMENTS MWA, MSP_WEB_TIME_PERIODS mwpWHERE Not Exists (select * from MSP_WEB_WORK_APPROVAL where CONVERT(VARCHAR,
— attempt to id non-reporters –find full list of resources select wr.res_name from MSP_WEB_RESOURCES WR,MSP_TEXT_FIELDS
MS Project Server KB Articles Home http://support.microsoft.com/ph/2526 MS Project KB Articles Home http://support.microsoft.com/ph/2525/en-us
http://tinyurl.com/bqhx8
