Hello,
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?
Thank you
Answer by Fatherjack · Jun 21, 2010 at 04:46 PM
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.
Database Mail (SQL2005) 1 Answer
Force database mail in SQL Server 2005 to change encoding base64? 2 Answers
How to create a mail alert when anybody accesses the database 1 Answer
SQL 2005 dbmail can not Send? 1 Answer
SQL DB Mail @Query Issue 2 Answers