>>Is there a SQL command I can use to get a list of all the tables along with the number of records in each table in a database?
>>
>>Thanks,
>>Einar
>
>

select rowcnt,object_name(id) 
>from sysindexes
>where indid < 2 and object_name(id) not like 'sys%'

Cetin


Thanks Cetin. I already awarded the solution stars but a single star is comming your way. Your way is a lot less "code"

Thanks,
Einar