SELECT ObjectName=Object_Name(i.object_id),PartitionNum=p.partition_number

,RowNumber=Rows,BoundaryOnRight=Boundary_value_on_right,BoundaryValue=Value

FROM sys.partitions p

Inner Join sys.indexes i ON p.object_id=i.object_id AND p.index_id=i.index_id

Inner Join sys.partition_schemes ps ON ps.data_space_id=i.data_space_id

Inner join sys.partition_functions f ON f.function_id=ps.function_id

Inner join sys.partition_range_values rv ON f.function_id=rv.function_id

AND p.partition_number=rv.boundary_id