>>>>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.
I will give it a try. I think it is a good idea for several reasons. Thanks again.
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.