I’ve done work for a few clients recently where I’ve created stored procedures or triggers in SQL Server which needed to send email. One of them was for a Microsoft Dynamics GP client where they wanted to send an email when a PR was converted to PO; sending emails in tis way uses a part of SQL Server called Database Mail.
Database Mail is installed but not configured by default, so using it requires that it be configured. I’ve not done this personally myself until recently when I needed to configure my demo VM to send this type of custom workflow notifications.
To enable Database Mail launch SSMS and connect to the SQL Server. Expand the Management node and right click on Database Mail and select Configure Database Mail:
Continue reading “How to Enable the Microsoft SQL Server Database Mail Feature”