Quick and dirty query to list all tables and row-count:

  
select t.name ,s.row_count from sys.tables t

join sys.dm\_db\_partition_stats s

ON t.object\_id = s.object\_id

and s.index_id = 1