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 |
|
Sitka
Aged Yak Warrior
571 Posts |
 Posted - 2002-11-18 : 13:55:50
|
SQL server is NT4 SQL7Web Server is Win2K with default SMTP virtual site with smart host configured to point to some third party pop3 server which is MailSite (if it is popular enough to mean anything), so no Exchange. I'd prefer not to use the MAPI mechanism. So I'm pumped because I have some CDONTS scripts that need to be rewritten as we bring down our last IIS4 box, one or two as needed on the win2K server have been changed to CDOSYS. The original intent was to use CDOSYS all around but know I'm not so sure.There is no IIS server or MAPI package on the SQL server and I would like to keep it that way. So I'm trying to get a plan together. Ideally I'd like to get the trigger driving the mailings but I'm starting to think in this cross version situation that may not be best or even work as described in articles and docs. Soooo.1.) This dosen't have to be real time maybe 5 times a day or so.2.) have the trigger populate a table to que up emails3.) have the website script evaluate that table, generate the emails via CDOSYS then flag the SQL mail que as sent.I have never set a taskwhich acceses a webpage but I think you can do it. seems the act of writing this makes it so  thanks sqlteam for the space to work this out.Comments and gut feelings appreciatedVoted best SQL forum nickname...."Tutorial-D"Edited by - Sitka on 11/18/2002 14:10:50 |
|
|
|
|
|
Mail yet again, network config comments welcome