• You can follow the below links to capture the row counts for all tables in a database.

    http://msdn.microsoft.com/en-us/library/bb510625.aspx

    http://www.mssqltips.com/sqlservertip/2537/sql-server-row-count-for-all-tables-in-a-database/