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
Softvative Inc. was built on the principles of providing innovative solutions, quality products and reliable services. We deliver clients’ success by paying close attention to their business needs, following the latest trends in technology and applying industry best practices to develop optimal solutions.