select 
	convert(varchar(50), obj.name) [table],
	ndx.rows
from 
	sysindexes 	ndx,
	sysobjects	obj
where 
	indid < 2
	and ndx.id	=	obj.id
	and obj.type	=	'U'
	and obj.name	!=	'dtproperties'
order by
	obj.name