James_DBA (2/10/2009)
Thank you for the compliment.It absolutely is wonderful to see the row count for each table, the purpose behind the final (total) count is very useful in cases of replication and/or migrating of databases to new servers. Some cases I've found myself replicating a database with 1,000s of tables in it and reviewing each record count per table is a very daunting task.
In my case, am setting up a semi-perm table with the output of the query so I can check data growth on a weekly basis. Have been surprised to find one of the DWH tables grew by 750,000 rows in the past 4 days...
Many thanks for reposting very useful code, and for acknowledging the original contribution as you did - big thumbs up to both of you and this miraculously useful forum.
--Code modified from original posting on SQLServerCentral.Com
--URL: http://www.sqlservercentral.com/scripts/Miscellaneous/30324/