Tool to send email via sql server:

https://mailsend.googlecode.com/files/mailsend1.17b12.exe

— Sample:

SET @strDestino=’C:\\Log\\mailsend.exe -to ‘+@strCorreos  
  SET @strFrom=’ -from contacto@tootlesoft.com -starttls -smtp smtp.gmail.com -port 587′  
  SET @strSubject=’ -sub ERP_Alerta_’+@strNombreDocumento+’ -auth-plain -user contacto@tootlesoft.com -pass contactot00tl3′  
 
   
  SET @strResult=@strDestino+@strFrom+@strSubject+@strTexto

   EXEC xp_cmdshell @strResult 

Advertisements