--allpage
use DBName
go
select name,sysstat2 from sysobjects where type='U' and (sysstat2 &  8192 ) =  8192 
go
--datapage tables 
use DBName
go
select name,sysstat2 from sysobjects where type='U' and (sysstat2 &  16384 ) =  16384 
go
--datarow tables 
use DBName
go
select name,sysstat2 from sysobjects where type='U' and (sysstat2 &  32768 ) =  32768 
go