>>>Don't you think that it is an overkill for a simple job. I would simply use a T-SQL like this:
>>>
>>>

select object_name(si.id),si.rowcnt from [sys].[sysindexes] si
>>>	inner join [sys].[tables] st
>>>		ON si.id = st.[object_id]
>>>	where si.indid<2 and st.is_ms_shipped = 0
>>>      order by object_name(si.id)

>>>
>>>Cetin
>>
>>Is it only for tables having indexes?
>
>No, why do you think it is?
>PS: However it is better to use Rows instead of RowCnt (table might be partitioned).
>
>Cetin

Thanks. For some reason I thought since it's an inner join to sysindexes it means table should have indexes (as the name suggests). Thanks again.