|
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. many thanks
(comments are locked)
|
|
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? Hi Kev Thanks for your reply. I am using the inbuilt email function. I want to change the 'Alert name here' occurered on \Yourserver. I want to change the \Yourserver name to something other than default server name. cheers
May 17 '12 at 07:44 AM
mickyd
AFAIK you can't change that. The workaround would be to have a job that calls a stored procedure that generates your own email (subject line etc), and then change the Alert properties (in Response tab) to execute the job.
May 17 '12 at 07:53 AM
Kev Riley ♦♦
Why wouldn't you want to see what server is firing the alert?
May 17 '12 at 07:59 AM
Kev Riley ♦♦
(comments are locked)
|
