In SQLSever 2005 msdb.dbo.sp_send_dbmail is the new way of sending email and it replaces xp_sendmail. Below are the steps how to setup Database Mail to use msdb.dbo.sp_send_dbmail. -- To check if "Database Mail XPs" option is turned ON use master go sp_configure 'show advanced options',1 go reconfigure go sp_configure 'Database Mail XPs' go sp_configure 'show … Continue reading How to setup Database Mail on SQL Server 2005?
Tag: send
How to send an email not using xp_sendmail in SQLServer?
From the following KB article it list couple of store procedures which can be used to send email through SQLServer. One of the feature it has the "From/Sender" can be passed in a parameter where as in case xp_sendmail it can't be. http://support.microsoft.com/kb/312839
alexlima.com 