Database & Application Miscellaneous: xp_sendmail on Windows Server 2003?

• jeremyswift / 212 / Fri, 15 Jan 2010 13:44:00 GMT / Comments (1)
• What's the simplest way to get a MAPI service up and running on
  Windows Server 2003 Std Edn?
  I want the database to send an email to our administrators when
  there's a holdup with replication. Have the stored proc ready to test
  but no MAPI service as yet. 'Twas easy with NT but seems to have
  become increasingly unfashionable...
• Keywords:

  xp_sendmail, windows, server, 2003, database, application

• http://database.itags.org/database-application/157937/«« Last Thread - Next Thread »»

• 1. quote:

     ---

     Originally posted by Jeremy Swift
     What's the simplest way to get a MAPI service up and running on
     Windows Server 2003 Std Edn?
     I want the database to send an email to our administrators when
     there's a holdup with replication. Have the stored proc ready to test
     but no MAPI service as yet. 'Twas easy with NT but seems to have
     become increasingly unfashionable...

     ---

     
     
     Hi There,
     I got sick of fighting with this myself.
     I think the Microsoft's responce to this is Install Outlook!
     Depening on which version you have you may need to leave outlook running all
     the time!
     
     In the end I found a couple of little utilities to get around it. Not in qu
     ite the same way be I find it very effective.
     
     One is called FileNotify
     It watches for changed / new files or folders and performs what ever action
     you like when it finds one.
     
     The other is called Blat.
     It is a smtp email client.
     
     Then I put the two togeather. I just get what ever I'm trying to monitor to
     create (or add to) a file in a particular folder. FileMonitor spots the ch
     ange and it calls blat to send it to me.
     
     Just simple scripting stuff. Reply if you would like me zip up all the piec
     es for you. I'm not sure if I'm supposed to redestribute this stuff but I'm
     sure it is all downloadable if you go looking.
     
     David.

     pollardd | Tues, 20 May 2008 00:23:00 GMT |