How to send e-mails with SQL Server Procedure? Strategies...

• lopes80andre

  SSC Veteran

  Points: 249

  More actions

  September 17, 2009 at 3:30 am

  #141745

  Hi,

  I need to send an e-mail in a SQL Server Procedure. Wich is the best way to accomplish this task?

  Best Regards,

  André Lopes.

• SQLZ

  SSChampion

  Points: 12872

  More actions

  September 17, 2009 at 8:39 am

  #1055017

  you can use sp_send_db_mail. You'll have to set up a database mail profile but once that's done it's pretty straight forward with sp_send_db_mail.

  Karl
  source control for SQL Server