Row Counts for all the Tables in a DataBase

(1)
SELECT CAST(OBJECT_NAME(id) AS VARCHAR(40)) AS 'Table',
       ROWS AS 'Rows'
FROM sys.sysindexes
WHERE OBJECT_NAME(id) NOT LIKE 'sys%' AND indid < 2
ORDER BY 'Table';
------ OR -------

(2)
SELECT o.name,   ddps.row_count 
FROM sys.indexes AS i  
  INNER JOIN sys.objects AS o
  ON i.OBJECT_ID = o.OBJECT_ID  
  INNER JOIN sys.dm_db_partition_stats AS ddps
  ON i.OBJECT_ID = ddps.OBJECT_ID  
  AND i.index_id = ddps.index_id 
WHERE i.index_id < 2 
  AND o.is_ms_shipped = 0
ORDER BY  ddps.row_count