Tuesday, September 15th, 2009

How can I generate an email in SQL Query Analyzer that will send the result of a query to specific recipients?

I’m using SQL Query Analyzer version 8.00 194. I have a query that returns several lists of items. I then take the lists and email them to the people who need them. I’m trying to automate this within query analyzer.

As far as I know, there is no way to do that in Query Analyzer, it’s not really the right tool for what you are trying to do. I would recommend looking at DTS packages in SQL, these can definitely do what you are trying to do.

This entry was posted on Tuesday, September 15th, 2009 at 11:18 am and is filed under automated analyzers. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “How can I generate an email in SQL Query Analyzer that will send the result of a query to specific recipients?”

Daniel B Says:
September 15th, 2009 at 4:26 pm

As far as I know, there is no way to do that in Query Analyzer, it’s not really the right tool for what you are trying to do. I would recommend looking at DTS packages in SQL, these can definitely do what you are trying to do.
References :

TheMadProfessor Says:
September 15th, 2009 at 4:37 pm

I’d agree with Daniel. Query Analyzer is a development tool, not an application builder.
References :

Leave a Reply