Morning all. Could anyone tell me the location where I would change the details sent in the email header for a SQL Alert I have set up. Require to change the server name from from the header.Seems to set as default machine name , need to amend it.
asked May 17 '12 at 07:29 AM in Default
Alerts are configured in SSMS under SQL Server Agent -> Alerts.
If you have configured the alert to run a specific job and the email is being sent from there using sp_send_dbmail, then you can change the subject line.
If you are using the inbuilt email notification and are getting subject lines such as :
Then I'm not sure you can change the subject line.
What are you getting and what do you want to change?