Any MSSQL 2008 R2 DBA's out there

[MTT]

I am working with a Software vendor on an issue I am having with purging of old data.

The Question from them,

Have you set up partitioning, if yes what is the date of the oldest partition?

Yes Table partitioning is set for this Data Base.

HOW DO I find the oldest partition?

I found a view called partitions with a create date of 6/18/2012 17:40:xx

But I don't know if that means oldest partition creation time. {that exists now}

Anyway,

If its easy and you can point me to the right tool where its just displayed?

Thanks for looking

[MTT]

No takers?

well my DBA does not know, and Genesys tech support has not responded to the question (How would I get that information?

[CuriousGeorge]

Look into sys.partition_functions and the related sys.partition_parameters & sys_partition_range_values, your DBA should be able to piece it together from technet [Creating Partitioned Tables and Indexes]
Hope that helps