can you upgrade this to 2008, please?
and is this query over all efficient? to see all user tables with data?
select OBJECT_NAME(id), rows from sysindexes i join sys.columns c
on OBJECT_NAME(i.id) = OBJECT_NAME(c.object_id) and
i.indid in (0,1) and
i.rows <>0 and
c.name = 'salesno'