SQL Monitor: location of email templates
zachlee47
Posts: 1 New member
Are the email templates in a stored procedure or a db_table? Can anyone point me in the right direction? I am looking to edit the default subject line to include the name of the database that generated the alert.
Example:
Current: Deadlock (extended event) | 1 - Production | %servername% (Raised: Medium)
Ideal: %db_name% Deadlock (extended event) | 1 - Production | %servername% (Raised: Medium)
Tagged:
Answers
Thank you for reaching out on the Redgate forums.
I'm afraid that it is not possible to customise the Alert email that SQL Monitor sends out.
This may be a good suggestion to make in the SQL Monitor Uservoice Forum though, if this then receives enough traction it could be a feature in the future:
https://sqlmonitor.uservoice.com/forums/91743-suggestions