No doubt the solution posted by xanthos (Posted 5/12/2008 2:35 PM) will be very useful to some. I cannot use this solution because of the potential security risks. ...

To answer the one reader, no I was not able to get it to work - datasrouces from across two different RDBMS'. My solution is not a solution...

This is a super cool article. Let me repeat, this is a super cool article. What a refreshing read!

I look back on all the TSQL I have...

Hmm, Xp_cmdShell huh? Hmmm. If it works, it works. Although....ah forget it. This one has been beat to pulp.

Thanks for the article.

-M

Fantastic article! This was a good read.

I may use this technique for my one of my websites. I use SQL2k5 and was going to integrate RSS...

As one who is analytical, precise, and leaves nothing up for assumption, the question was written in a manner that is neither analytical, precise, and leaves EVERYTHING up for assumption....

Thank you, thank you, thank you. Written like a book. Great job.

-Mike

Great article. Thanks.

-Mike

I have other similar macro scripts that work in SQA and not SSMS. It has been really frustrating not to be able to use them effectively in SSMS -...

Yes, indeed, it treats the whole comma delim'd parameter as a string - BUT ONLY IN SSMS.

It works perfectly in SQA. I can't figure out why. One forum...

Use the feedback you are receiving constructively. There are many solid, spot-on points that have been mentioned. In my humble opinion, it is always good practice to seek...

Holy Cow! How did you ever figure that one out! It is great information. Perhaps I should add a sub-routine to my script to take into account...

F4 certainly works. In my humble opinion, it takes too long :).

While I am typing in SQA and SSMS, I use two macors all of the time:

sp_help and sp_helptText....

I concurr with, "Too many sql programmers are behind the curve" comment. Good stuff Troy and Thank you.

To cs_Tryok:

The image is very cool and very useful. Thank you very much. I am sure all who see it will find value in it as I have.

-Mike