Database Mail and XP_Sendmail

• PJ-200411

  SSC Enthusiast

  Points: 156

  More actions

  January 5, 2006 at 8:43 am

  #166669

  Hi All

  I have migrated a SQl 2000 db to SQL 2005. The origininal db contained triggers that used the XP_Sendmail procedure to send emails on inserts/deletes...

  I have configured SQL 2005 not to use SQL Mail but Database Mail, which is configured and working fine and had no intention of using SQL Mail on this server. I am hoping there is an equivalent procedure to XP_sendmail or simple method to send mail from withing my code using Database Mail.

  Any help would be much appreciated.

  Thanks

  PJ

• PJ-200411

  SSC Enthusiast

  Points: 156

  More actions

  January 6, 2006 at 3:19 am

  #613140

  I have fouhnd the solution from another post, the procedure that I am looking for is sp_send_dbmail.

  Thanks

  PJ