There are databases with several data files(segment).

For example, db name is triffic_db. It has two data files named
triffic_a_data and triffic_b_data. Those two could be just primary file groups or separate file groups.

I am trying to pull out separate space report on these two separate data files.

Been looking at sysfile, sysindexes with groupid, fileid columns. No luck so far !

No access to the MS server 2000 system table map which shows relationship among those.

Anyone know how to pull out these detailed report from sql2k(ver 8.0) ?