Sending Email via MsSql

Microsoft’s Sql Server always required an odd if not cumbersome configuration in order for emails to be sent by Sql Server itself. An extremely lightweight method of sending emails through mssql is using xp_smtp_sendmail. Xpsmtp adds an extended stored procedure with allows you to easily send emails from Sql Server.