Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
manny
Starting Member
14 Posts |
 Posted - 2006-02-25 : 14:33:26
|
| I've been through a fair few webpages and there seem to a number of ways to send out emails from SQL Server, can anyone from experience point me to the best one (I'm using SQL Server 2000).many thanks. |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-02-25 : 14:43:35
|
| We send them from a client app. (using a rather nice COM object that seems to handle all the intricacies of Emailed rather well) We have a table in SQL Server that holds the TO: address, subject, message, etc.The Client app logs what fails/bounces/etc.Getting SQL Server to send the Emails itself requires that you install Outlook on the server (to get sufficient MAPI stuff to enable sending Emails). I'm definitely in a minority amongst my peers on SQL Team, but that scares the bejasus out of me on a secure production server!Kristen |
 |
|
|
manny
Starting Member
14 Posts |
Posted - 2006-02-25 : 14:56:51
|
| I'm developing on a test server.. actually its not even a server, its my windows xp home edition laptop :)Numerous reasons for this, but so it seems to be doing the job. I have outlook express installed, prefereably I want sending out emails as self contained within SQL Server as possible. I have the option of using Coldfusion to do the email handling, but will only use this if my attempts to do it in SQL fails. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-02-25 : 15:23:28
|
| I'm not entirely sure, but I think that Outlook Express is NOT enough "MAPI" for SQL Server to be happy. I'm happy to be proven wrong though! |
|
|
|
manny
Starting Member
14 Posts |
Posted - 2006-02-25 : 15:43:57
|
| I also have Microsoft Outlook installed. |
|
|
|
manny
Starting Member
14 Posts |
Posted - 2006-02-25 : 22:09:37
|
| using COM objects, are there any which allow quering the database and emailing the results? |
|
|
|
raclede
Posting Yak Master
180 Posts |
Posted - 2006-02-27 : 00:06:53
|
| Yah. I agree with Kristen its better to create an application the handles the email. In our company we have a generic email notifier. The only parameters are XSLT Path and Stored Procedure to execute. The email notifier just query to database using the Stored Proc then converts it to XML. Lastly it transforms XML to Email using XSLT. |
|
|
|
|
|
|
Simplest way of sending an email using T-SQL