DECLARE @TableName VARCHAR(255);

SELECT TABLE_NAME AS TableName, null AS RowCnt
INTO #TempTableCounts
FROM INFORMATION_SCHEMA.TABLES 
WHERE TABLE_TYPE = 'base table';

WHILE (EXISTS(SELECT * FROM #TempTableCounts WHERE (RowCnt IS NULL))) BEGIN
	SELECT TOP(1) @TableName = TableName FROM #tempTableCounts WHERE (RowCnt IS NULL);
	EXEC ('UPDATE #TempTableCounts SET RowCnt = (SELECT count(*) FROM ' + @TableName + ') WHERE (TableName = ''' + @TableName + ''')');
END

SELECT TableName, RowCnt FROM #TempTableCounts;

DROP TABLE #TempTableCounts;

SELECT name [Table], sum(row_count) AS [Rows]
 FROM sys.dm_db_partition_stats  WITH (NOLOCK), sysobjects  WITH (NOLOCK)
WHERE index_id < 2	-- Just grab index 0 (heap) or 1 (cluster)
  AND xtype = 'U'
  AND object_id = object_id('' + name + '')
GROUP BY name