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 |
|
jeroena
Yak Posting Veteran
76 Posts |
 Posted - 2004-10-27 : 07:52:09
|
| Hello all,I'm looking for an SMTP mail solution for SQL Server. I've build a solution which uses the JMail object and the sp_OACreate procedures, but I know there are others as well, for example CDO. My question: do these objects run in-proces with the SQL Server proces, because if they do, that wouldn't be a satisfying server solution.Any ideas on how to avoid this?Thnx., Jeroen. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-10-27 : 08:09:44
|
| I never send emails from an app but put the email request into a table and attachments into a directory then another process sends the emails.The process can be a proc that uses xp_sendmail from another server or anything - doesn't matter as long as it isn't installed on an important server and gets monitored (could be an xp_sendmail from a job if you only have one server but that's not particularly good).The important thing is to make sure that your system doesn't stop working just because you have a mail failure.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
jeroena
Yak Posting Veteran
76 Posts |
Posted - 2004-10-27 : 08:12:43
|
| I just don't want it in the same proces. Same server is ok with me. I don't think using another SQL Server is a very nifty solution... |
|
|
|
|
|
|
e-mail sending COM objects