Query to check Projects with Special Characters

Share on facebook
Share on twitter
Share on linkedin
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.
-- MSPS 2013 SQL Query to Find projects with special characters in the name
--by: Faisal Masood (www.softvative.com) PMP, CCNA, ITIL, MCSE, MCITP, MCTS, MCSA, MOS, MS

select Proj_name, PROJ_PROP_AUTHOR, PROJ_LAST_SAVED, WPROJ_LAST_PUB, WPROJ_STS_SUBWEB_NAME FROM pub.msp_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

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

Sign up for Softvative Newsletter

Receive the latest technology and leadership news and resources from us

Subscribe To Softvative Newsletter

Get notified about new articles

Share on facebook
Share on twitter
Share on linkedin
Share on pinterest