>>>Of course, even if MS did remove them, they are easily access in the Master DB, and could be copied to the new version (assuming no underlying functionality was lost). I am going through them and trying to understand how they work.
>>
>>You may want to write several versions of this SP based on various techniques (sysindexes - may be not 100% accurate), sp_MS_ForEachTable, your original cursor approach, Borislav's version and then compare speed for each one of them.
>
>Not a bad idea, though the results will be close. We are not iterating through a long list, there are only about 150 tables in this database. Actually that may be not a small number of tables for a database, but not a large number for a query. :)

I think it's a big number and the difference will be shown. But I don't know for sure.