locked
Trying to edit the display name when sending an email RRS feed

  • Question

  • Hello All,

    I have created a database profile and finished setting up the database mail.Right now my subject is AMC SQL ALERTS and I am trying to change this to AMC SQL ALERTS_WHD_BACKUP...I have changed this in display name..But I am still getting the same AMC SQL ALERTS when email has been sent..Please help..

    Thanks

    Tuesday, March 13, 2012 1:45 PM

Answers

  • Hi Srisql,

    Do you want to change the subject line? How did you change the subject name? 

    You can try to send a test mail and manual change the subject line for the email in the subject box. Or you can test email from SQL Server to execute the statement below likes:
    declare @body1 varchar(100)
    set @body1 = 'Server :'+@@servername+ ' My First Database Email '
    EXEC msdb.dbo.sp_send_dbmail @recipients=’’,
        @subject = 'My Mail Test',----change the subject line here
        @body = @body1,
        @body_format = 'HTML' ;

    For more information, please refer to Troubleshooting Database Mail: Sending Test E-Mail

    If you changed success please verify subject line message using  sysmail_allitems. For  more information, please refer to this article.

    Regards, Amber zhang

    • Proposed as answer by amber zhang Tuesday, March 20, 2012 6:26 AM
    • Marked as answer by Iric Wen Tuesday, March 20, 2012 8:34 AM
    Thursday, March 15, 2012 5:59 AM