SQL-ссылки (Send Email from SQL Server Express Using a CLR Stored Procedure)

http://www.mssqltips.com/tip.asp?tip=1795

Imports System.Net
Imports System.Net.Mail


Public Class StoredProcedure
_
Public Shared Sub spSendMail(ByVal recipients As String, ByVal subject As String, ByVal from As String, ByVal body As String)
Dim mySmtpClient As SmtpClient

Using myMessage As New MailMessage(from, recipients)

myMessage.Subject = subject
myMessage.Body = body

myMessage.IsBodyHtml = True

mySmtpClient = New SmtpClient("mail.yourservername.com")
mySmtpClient.Credentials = New NetworkCredential("email@domain", "yourPassword")
mySmtpClient.Send(myMessage)

End Using
End Sub
End Class