Get Record Counts for Each Table

create procedure DBA_GET_TBL_REC_CNT as
begin
set nocount on
create table #reccount (tbl_name varchar(100), rec_count int)
exec sp_MSforeachtable 'insert #reccount select ''?'',count(*) rec_count from ?'
select * from #reccount order by tbl_name
end
go