>>>>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?
Just google on it, it will return lots of hits. I forgot about it too, but I saw it used and recommended couple of times.
Here is one link I opened and tried:
http://www.databasejournal.com/features/mssql/article.php/1490661Also please check my original first message, I updated it with the sample code.
If it's not broken, fix it until it is.
My Blog