Query to check Projects with Special Characters

Version: 3.0, Updated on: 01/24/2017
 
The cube build process in MS Project Server 2003 could fail due to special characters. You can use the following SQL query to look for projects with special characters in their names.

Click here to download the SQL query file.

 
Once you have the list, use the Rename Project tool to rename those projects. Make sure to look for any pending updates. After renaming make sure to publish those projects.
 

Leave a Reply

Enter the CAPTCHA * Time limit is exhausted. Please reload CAPTCHA.