Table Rowcount

SELECT distinct

    t.NAME AS TableName,

    p.[Rows]

FROM

    sys.tables t

INNER JOIN

    sys.partitions p ON t.object_id = p.OBJECT_ID

WHERE

    t.NAME NOT LIKE 'dt%'

ORDER BY

    t.NAME