>>>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.
I have not heard of these procedures before. Do you know if there is any information on them?
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.