Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to change the subject of alert email in SQL SERVER 2008 R2 Expand / Collapse
Author
Message
Posted Wednesday, November 21, 2012 9:31 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 29, 2014 5:46 PM
Points: 182, Visits: 737

Hi Everyone,

I have set up some alerts for mirroring monitoring, and in case of failure we recieve notification emails.Is there any way that I can change the subject of email.Because on the subject of email, we see "SQL Server Alert System: 'DB Mirroring State: No Quorum' occurred on \\", How can we change the ''\\" to the server name that error has happned?


Thanks
Post #1387487
Posted Thursday, November 22, 2012 5:32 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 5:16 AM
Points: 1,980, Visits: 3,349
Check in your DB Mail account profile that the Display name field has something in it.
Post #1387854
Posted Tuesday, November 27, 2012 12:13 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, February 4, 2013 12:43 AM
Points: 10, Visits: 45
Well being techy You have one more option to get a user defined subject in email notification you can try third party tool also

Try out available tools for Storage management for SQL
Post #1388988
Posted Tuesday, November 27, 2012 12:23 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 3:56 AM
Points: 251, Visits: 614
see if you can use procedure sp_send_dbmail
where you can change your Subject of email according to requirement
and append your server name or address
Post #1388993
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse