| By product |
| Other |
|
Knowledgebase Tips and How-to Articles for ApexSQL Tools How to send email alerts when a change is made to a database record Applies to ApexSQL Audit Summary This article shows how to customize ApexSQL Audit architecture so that email alerts are sent when changes are made to a database record Database Mail must be configured and this solution can only be used with MS SQL Server 2005 and later Description 1. Configure Database Mail 2.Download ApexSQL2049_Mail.audx here. This architecture is customized for sending email alerts when a change occurs. Save this file in ApexSQL Audit installation folder 3. Start ApexSQL Audit and connect to the database you want to audit 4. Click File | Select Audit Architecture and select ApexSQL2049_Mail.audx 5. Click File | Template Editor to modify the template 6. Find and modify the following lines of code Customize the following values: Mail_Profile = "John" Mail_Recipients = "John@mymail.com" Mail_Body = "Please verify database change." Mail_Subject = "Unauthorized Database Change" 7. Click Run | Process and save the architecture file 8. Close the Template Editor 9. Create the triggers. If the triggers have already been created, recreate them When fired, the triggers created using this template will not only store audit data but will also send email alerts indicating that a change has been made Last update November 30, 2011 Labels: Apex SQL Audit |
