declare @sql varchar(8000)
select @sql=''
select @sql=@sql+'select count(*) ids from '+name+' union all ' from (
select name from sysobjects
where xtype='u') a
select @sql=substring(@sql,1,len(@sql)-10)
select @sql='select sum(ids) from('+@sql+') a'
execute (@sql)