>>>>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.
No you are wrong. It doesn't mean that table should have indexes. SysIndexes doesn't only hold information about tables that have indexes and it is clearly documented.
Cetin