Database Mail SQL 2005 Mail Subject

• Matt B-336497

  Newbie

  Points: 1

  More actions

  June 13, 2006 at 10:41 am

  #94263

  Does anyone know how to change the mail subject? Default is "SQL Server Message" and I would like to be able to set it up so that in the message subject it is unique to each type of notify. It may be right in front of me and I am at complete saturation but any help would be great.

• TShubick

  SSC Veteran

  Points: 218

  More actions

  June 14, 2006 at 6:55 am

  #643621

  Use the @subject parameter:

  exec

  msdb..sp_send_dbmail @profile_name='DBMail',@recipients = 'sql.administrators@company.com',@body = @msg, @subject = 'New Subject Line'