How to retrieve All Tables and Number of Rows on Sql Server.

SELECT OBJECT_NAME(Object_id) As TableName, SUM(Rows) As TotalRows

FROM sys.partitions

WHERE OBJECTPROPERTY(Object_id, 'IsUserTable') = 1 AND Index_ID IN (0,1)

GROUP BY OBJECT_NAME(Object_id)

ORDER BY TableName;