title: Can SQL Server send a notification via email?
body: <p>Does SQL Server has the ability to send a notification to a specific email address when some events have been triggered?</p>
  
  <p>Context: I have a table contains a lot records about many partners. I wish if any partner's records have been changed, the SQL Server will send an email including all the changed records to the partner.
  There are at least 100 partners in the table. So SQL Server needs to know which email address to use.</p>
  
  <p>Does anyone know if SQL Server has the ability, and how can I implement it?</p>