In views\systemviews for your database there is a sys.sysfiles view that contains that information.t in SQL Server 2008. Previous versions I'm not sure about.

The execution plans were identical using the view and the synonym. Thanks again.

Thanks All.

I can add a little clarification, if this will make a difference. The partitioning on the original table was done on Year/Month. It was done mainly for the benefit...