Our company doesn't have a SQL DBA so some of the responsibilities fall to our Microsoft Infrastructure Team, which I happen to be on (lucky me)
We have a server running SQL 2005. There was an alert set up to email specific users on error number 50018. The user is asking me if there's a way to enter a custom subject for the alert email he receives. If nothing else, he'd like to drop off the "SQL Server Alert System" from the subject line. Does anybody know of a way that I can do this?
asked Jun 21 '10 at 03:59 PM in Default
I dont think there is much you can change on alerts themselves. Have you found where they are configured in SSMS? In object explorer under the SQL Agent section, expand Alerts and select the alert you want to work on.
What you could do to get the customisation you want is to use the alert to fire a job that sends the email formed in the way that you want it. I am thinking that if your arent SQL DBAs then that may just be making a load of work that you dont need.
answered Jun 21 '10 at 04:46 PM