Sending emails from sql sever

Question

What is the best way to send email from sql server 2008 (script).

Any sample or online links please.

Answer 1

I think this is something you might try googling:

http://classicasp.aspfaq.com/email/how-do-i-send-e-mail-from-sql-server.html

Answer 2

Here's a way to do it through the CLR.

Answer 3

Using the Database Mail feature and the built-in procedure sp_send_dbmail.

Answer 4

I know this has been answered and accepted but I had the same question did a little research and blogged about my solution here

Maybe this will help someone who stumbles across this in the future.