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?