Hi Think this may help you

select a.Name,b.rows from sysobjects a, sysindexes b where a.type='u' and a.id =b.id and b.indid<2


regards
Eswar

-----Original Message-----
From: Chip Smith [mailto:[Email Address Removed] Saturday, November 22, 2003 3:27 AM
To: LazyDBA.com Discussion
Subject: Rowcounts in sql server



I want to count all of the rows for all of the user tables in all of the
databases, one at a time. Can this be done from within sql server or do I
need seperate procs for each db.
There are many db's.

TIA

-- chip
MS Sql Server LazyDBA home page