Resolution for Project Managers (Project Server 2003 only)
Project managers can check in their own checked out projects by completing the following steps:
1. Log into Project Web Access with project manager permissions.
2. Click the Projects menu to navigate to the Project Center page.
3. Click the Check in my projects link in the sidepane on the left.
4. In the data grid, select the checked out project and click the Check-In button.
Resolution for Administrators (Project Server 2002 or 2003)
Project Server administrators can check in projects and resources that are stuck in a checked out state by completing the following steps:
1. Log into Project Web Access with administrator permissions.
2. Click Admin > Manage Enterprise Features.
3. Click either the Check-in Enterprise Resources link or the Check-in Enterprise Projects link in the sidepane.
4. In the data grid, select the checked out project or resource and click the Check-In button.
Resolution for SQL Server DBA’s (Project Server 2002 or 2003)
Projects can occasionally become stuck in a checked out state, but they do not show up in the data grid using either set of above steps. In this case, a SQL Server DBA must perform the following steps to check in the project:
1. Launch the Microsoft SQL Server Enterprise Manager.
2. Select and open the Project Server database.
3. Select the MSP_PROJECTS table and open it.
4. Locate the checked out project.
5. Set the value in the PROJ_CHECKEDOUT field to 0 (zero) for the project.
Note: For a resource that is stuck in a checked out state, open the MSP_RESOURCES table and set the RES_CHECKEDOUT field value to 0 for the checked-out resource.