I believe this works well as long as the statistics are up to date.

Brian Freeman
Carnegie Technologies/Bluewave Computing
(770) 916-0595 ext. 415
www.carnegie.com/www.bluewave-computing.com



-----Original Message-----
From: Kumar, Eswar M (EM, GECIS) [mailto:Eswar.[Email Address Removed]
Sent: Monday, November 24, 2003 11:48 AM
To: LazyDBA.com Discussion
Subject: RE: Rowcounts in sql server


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

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Get
today's cartoon: http://www.LazyDBA.com To unsubscribe, e-mail:
mssqldba-[Email Address Removed] For additional commands, e-mail:
mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page