Re: Any mapping from cxyz.dat to Entities ?

[Bryan Pendleton]

Anyway to figure out which object (Table/row?) is holding this space ?

For a file named cNNN.dat, the NNN is in hex. Convert it to decimal DDD,
and plug it into this query:

select t.tablename, c.conglomeratenumber
       from sys.systables t,sys.sysconglomerates c
       where t.tableid = c.tableid
         and c.conglomeratenumber=DDD;

Or just skip the second 'and' clause and convert the conglomeratenumber
to hex and look for a matching cNNN.dat.

So, for example, if you're interested in C990.DAT, since 990 in hex is 2448
in decimal, so you can run

select t.tablename, c.conglomeratenumber
       from sys.systables t,sys.sysconglomerates c
       where t.tableid = c.tableid
         and c.conglomeratenumber=2448;

thanks,

bryan