ptn_data_pgs( object_id, partition_id )
Returns the number of data pages used by a table partition.
Example
select object_name(id), ptn_data_pgs( id, partitionid ) from syspartitions