SELECTQUOTENAME(SCHEMA_NAME(sOBJ.schema_id)) + '.' + QUOTENAME(sOBJ.name) AS [TableName]
, SUM(sPTN.Rows) AS [RowCount]FROM
sys.objects AS sOBJ
INNER JOIN sys.partitions AS sPTN
ON sOBJ.object_id = sPTN.object_idWHEREsOBJ.type = 'U'AND sOBJ.is_ms_shipped = 0x0
AND index_id < 2 -- 0:Heap, 1:ClusteredGROUP BY sOBJ
.schema_id, sOBJ.nameORDER BY [TableName]GO
DECLARE @TableRowCounts TABLE ([TableName] VARCHAR(128), [RowCount] INT) ;INSERT INTO @TableRowCounts ([TableName], [RowCount])EXEC sp_MSforeachtable 'SELECT ''?'' [TableName], COUNT(*) [RowCount] FROM ?' ;SELECT [TableName], [RowCount]FROM @TableRowCountsORDER BY [TableName]
