1. Skip to Menu
  2. Skip to Content
  3. Skip to Footer>

Expert Sessions!

Configure Database Mail, sp_send_dbmail

Tuesday, 31 July 2012 11:31

Written by Prakash Palani

Print E-mail


Here are the steps to configure Database Mail in Microsoft SQL Server, please note that these steps are only valid to Microsoft SQL Server 2005.  Please refer to article http://basisondemand.com/mss/script_to_monitor_transaction_log_space_and_alert_dbcc_sqlperflogspace to understand, how this functionality can be used in a stored procedure/scripts.

Choose Database Mail under / - > Management -> Database Mail






Make sure that you are able to telnet to the SMTP server and the port that’s used for SMTP relay in your environment.




{fcomment} {flike}


Configure Database Mail, sp_send_dbmail