MS SQL Server, Count rows for all tables in db

Count rows for all tables in db The following will give what you want. dbcc updateusage (pubs) with ...

www.databaseteam.org