Hi Jeff,
I do agree it doesn't really make sense to use a new tool just because it exists. Also, I do tend to lean toward if it can be done in t-sql then do it there. Still I am open if new tools, such as powershell, if they have a better way of doing things. I am familiar with some of the old things so it does give me a basis to judge if this new tool is the right one to use or not. That is a pretty funny comment about what is DOS? I have gotten that before as well. It seems like some people are a little more familiar with command prompt, but not always.
I guess because I do have a programming background as well, I don't mind the loops as much. Still I would always prefer a set based solution in t-sql if at all possible.
Anyway, you have certainly given some food for thought. Perhaps some new articles will come out of this discussion. The need to learn some of the old "ways" of doing things. Since sometimes the old "ways" are better.
Ben
Thanks for the feedback, Ben. Heh... oddly enough, I used to be an application programmer, as well, but that's why I hate loops so much. 😉