Query to check Projects with Special Characters

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.

SELECT * FROM msp_web_projects
WHERE (Proj_name LIKE '%.%')
OR (Proj_name LIKE '%\%')
OR (Proj_name LIKE '%"%') 
OR (Proj_name LIKE '%/%')
OR (Proj_name LIKE '%:%')
OR (Proj_name LIKE '%;%')
OR (Proj_name LIKE '%|%')
OR (Proj_name LIKE '%?%')
OR (Proj_name LIKE '%''%')
OR (Proj_name LIKE '%<%')
OR (Proj_name LIKE '%>%')
OR (Proj_name LIKE '%*%')
OR (Proj_name LIKE '%#%')
OR (Proj_name LIKE '"%')
OR (Proj_name LIKE '%"')
OR (Proj_name LIKE '''%')
OR (Proj_name LIKE '%''')
OR (Proj_name LIKE '%&%')
order by proj_name

Once you found 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.