• An alternative without cursor is:

    sp_msforeachtable 'select ''?'', count(*) Rows from ?'

    Toni