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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-11-16 : 07:03:18
|
| Simon writes "Can you help me with this, we are trying to set up SQL mail to alert us of certain data states. The problem lies in the fact that we use Lotus notes as our email system which is not MAPI compliant, any help would be greatly appreciated.BTW the setup isWindows server 2003 (standard)MS SQL 2000Lotus Notes 6" |
|
|
MuadDBA
628 Posts |
Posted - 2004-11-16 : 11:37:56
|
| Well, thjere are custom stored procedures out there that use SMTP to send mail. look up xp_smptsendmail on google and you should find information about it. |
 |
|
|
jpiscit1
Posting Yak Master
130 Posts |
Posted - 2004-11-16 : 11:41:12
|
| We use sp_send_cdosysmail.Check this out:http://support.microsoft.com/default.aspx?scid=kb;en-us;312839&sd=tech |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
|
|
jpiscit1
Posting Yak Master
130 Posts |
Posted - 2004-11-16 : 22:50:47
|
| I am not completely certain of this Jen. We run Win2k with SQL2k SP3. Assuming IIS is running on the SQL box and you specify your SMTP mail server as the "smart host" , then I think yes.I'd be curious to know more about the .net alternative though...Your limits are only as far as you set your boundries.... |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-11-16 : 23:35:14
|
i think i'll explore the cdonts method...this is what i did.1. created a vb application (.net and .6) that will accept the email parameters, then sends this mail via lotus session opened in the application. you should have one lotus id in the server and have lotus application installed.2. created a table which has a trigger for insert. If you want to send mail, insert into the table the mail details (to,bcc,cc,body,subject). The trigger calls the vb application passing the "inserted" values and changing the status field to 1.3. if the mail was not sent, we have a schedule that sends the remaining mails based on the status field.i can send you the class for the mailing process  , just email me. if you'll use .net you'll need the .net framework installed (downloads are available)from other posts here though, i think the preference is aspmail.--------------------keeping it simple... |
|
|
|
Ionline
Starting Member
2 Posts |
Posted - 2004-11-29 : 05:32:29
|
| Hi Jen,In my application, I want to send an auto mail based on a date field (MS SQL Server). Can you please post the class for the mailing process. RegardsIonline. |
|
|
|
|
|
|
|
|
SQL Mail and Lotus Notes