the size and rows of each table in SQL 2000/2005

Declare @SourceDB varchar(20)
SET @SourceDB = 'CPFR_TEST'
set nocount on
declare @sql varchar(256)
create table #tables(name varchar(256))
select @sql = 'insert #tables select TABLE_NAME from ' + @SourceDB + '.INFORMATION_SCHEMA.TABLES where TABLE_TYPE = ''BASE TABLE'''
exec (@sql)
create table #SpaceUsed (name varchar(256), rows varchar(20), reserved varchar(20), data varchar(20), index_size varchar(20), unused varchar(20))
declare @name varchar(256)
select @name = ''
while exists (select * from #tables where name > @name)
begin
select @name = min(name) from #tables where name > @name
select @sql = 'exec ' + @SourceDB + '..sp_executesql N''insert #SpaceUsed exec sp_spaceused [' + @name + ']'''
exec (@sql)
end
select * from #SpaceUsed
drop table #tables
drop table #SpaceUsed