BRILLIANT !!! Thanx a lot.
B-) On Tue, Sep 1, 2009 at 9:51 PM, Bryan Pendleton<[email protected]> wrote: >> 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 > >
