Used_pgs

used_pgs( object_id, doampg, ioampg )

Returns the number of pages used by a table and its clustered index.

Example

select Object_Name(Id), IndId, Name, Used_pgs( Id, doampg, ioampg )

from sysindexes

where Id in (Object_Id('T_Feature'), Object_Id('T_ProdBillOfMat'))

and IndId < 2