This works for oracle. Crude but works. How can it be done with sql server?

spool on.bat
select 'spool results.txt' from dual;
select 'select count(*) ,'||''' rows in '||table_name||''' from
',owner||'.'||table_name||';'
from dba_tables where owner in(select username from dba_users)
select 'spool off' from dual;
select 'exit' from dual;
spool off
$on.bat

I want to count all of the rows for all of the user tables in all of the
databases, one at a time. Can this be done from within sql server or do I
need seperate procs for each db.
There are many db's.

TIA

-- chip
MS Sql Server LazyDBA home page