I very much enjoyed the article and think it will be very useful in my developement work.  To switch to using catalog views in SQL Server 2005 isn't difficult at all.

For the first example on getting counts you just have to make a small change from sysobjects to sys.objects and "type" instead of "xtype" like this:

select 'select ' + char(39) + name + char(39) + ' as dbtable, ' +

'count(*) as rows from [' + name + ']'

from sys.objects where type = 'u' and name not in ('dtproperties')

order by name

Thanks for the article!