[dba-SQLServer] NEVERMIND (Fw: executing system stored procedure)

I've tried several examples now -- they run, but they don't actually return 
anything -- this one creates the table, but doesn't fill it.

Susan H.


> Try this
>
> Just lifted it of the web
>
> use pubs
> go
> create table #rowcount (tablename varchar(128), rowcnt int)
> exec sp_MSforeachtable
>   'insert into #rowcount select ''?'', count(*) from ?'
> select top 5 * from #rowcount
>    order by tablename
> drop table #rowcount