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