Enterprise Calendars used by Enterprise Projects
The following SQL query can be run against the Project Server Published database to get a list of Enterprise Calendars used by Enterprise Projects in Project Server 2007.
select distinct
p.proj_name,
bc.cal_name
from
msp_projects p
join msp_project_calendars pc on pc.proj_uid = p.proj_uid
join msp_calendars bc on bc.cal_uid = pc.cal_base_uid
where
pc.cal_base_uid is not null
