DaveWentzel.com            All Things Data

Database Mail

 

was referred to as SQLiMail in earlier beta builds.
 
does not require MAPI or Outlook.  Uses SMTP to send emails.  It uses Service Broker to send emails asynch, so it scales better than sqlmail.  You can configure attachment sizes and restrictions.  Supported on 64-bit platforms as well.  It does NOT support reading emails. 
 
adds a status/logging record to the sysmail_log table.  The actual mail details are saved in the sysmail_mailitems table.  Run a SELECT on these tables to find out whether Service Broker was able to activate DatabaseMail90.exe and any problems encountered. 
 
sent_status field: 
0 = waiting to process
1 = success
2 = error with the smtp server
 
 

Add new comment