>>>>Wow. Thank you all. What a great response. Naomi, your links provided great information. Borislav, thank you for your dynamic SQL example. I have not used dynamic SQL much, but will definatly look to it more often. Sergey, you are always so helpful, and right on the money. I was able to put your example together with Borislav's (untested) to make it work.
>>>>
>>>>My hat's off to all of you. Your assistance and time are very appreciated.
>>>
>>>Just be aware that many DBA block Dynamic SQL for security reasons.
>>
>>So we may want to use undocumented SP_MSForEachTable procedure, but is there a possibility of dropping it?
>>
>>I've tested in SQL Server 2005, the procedure is still there.
>
>SP_MSForEachTable and SP_MSForEachDB are still there, but who knows when and WHY MS will remove them. I don't have SQL 2008 to be sure if they are still there, but if they are at least 15 years live for the code based on them.
>What I see now, NO DBAs with existing SQL Servers here wanted to move their systems to SQL Server 2005.

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.