<div>
You should be able to do that via a database table trigger ON UPDATE and I'll find a Experts Exchange previous solution for similar question.
</div>


You should be able to do that via a database table trigger ON UPDATE and I'll find a Experts Exchange previous solution for similar question.

IT Manager

Jim Metcalf

<div>
<div class="content wysiwyg-content">
I am trying to find an application that will produce the following functionality. &nbsp;Basically, i would like for this application to be able to monitor a sql database and send an email based on a record update. &nbsp; I don't want to use sql mail because these emails need to be highly formatted and possibly contain attachments.<br />
<br />
Example.<br />
<br />
We provide inspections of buildings. &nbsp; An inspector will use the application and &quot;result&quot; an inspection. &nbsp;Once this result is submitted to a certain column in the database table, i will need the application to recognize a result has been submitted. &nbsp;I will then want the application to pick up the applicant email address for this inspection and roll up the violations... again, submitted to the database in a formatted way and possibly attach a pdf that is generated by our SSRS reporting server. &nbsp;Does anybody know an application that can do that?
</div>
</div>


I am trying to find an application that will produce the following functionality.  Basically, i would like for this application to be able to monitor a sql database and send an email based on a record update.   I don't want to use sql mail because these emails need to be highly formatted and possibly contain attachments.

Example.

We provide inspections of buildings.   An inspector will use the application and "result" an inspection.  Once this result is submitted to a certain column in the database table, i will need the application to recognize a result has been submitted.  I will then want the application to pick up the applicant email address for this inspection and roll up the violations... again, submitted to the database in a formatted way and possibly attach a pdf that is generated by our SSRS reporting server.  Does anybody know an application that can do that?

Looking for an application that can generate emails off of sql

Within Internet message handling services (MHS), a message transfer agent or mail transfer agent (MTA) or mail relay is software that transfers electronic mail messages from one computer to another using a client–server application architecture. A MTA implements both the client (sending) and server (receiving) portions of the Simple Mail Transfer Protocol (SMTP). The terms mail server, mail exchanger, and MX host may also refer to a computer performing the MTA function. The Domain Name System (DNS) associates a mail server to a domain with mail exchanger (MX) resource records containing the domain name of a host providing MTA services.

Email Servers

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

An email client, email reader or more formally mail user agent (MUA) is a computer program used to access and manage a user's email. A web application that provides message management, composition, and reception functions is sometimes also considered an email client, but more commonly referred to as webmail.