Try this -


select substring(o.name, 1, 30) Table_Name ,i.rows Number_of_Rows
from sysobjects o
inner join sysindexes i
on (o.id = i.id)
where o.xtype = 'u'
and i.indid < 2 and o.name <> 'dtproperties'
order by o.name


-Bhuwnesh





-----Original Message-----
From: Sultana, Naheed [mailto:naheed.[Email Address Removed] Wednesday, November 27, 2002 12:01 AM
To: LazyDBA.com Discussion
Subject: Need Help with Script!


Hi List,

I need a script which can return the Row Count for all the tables I have .If
it's handy with anyone of you, pls forward me.



TIA



MS Sql Server LazyDBA home page