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? →