Table Design to Store Custom Email Subject & Body

• RJ-476420

  SSCarpal Tunnel

  Points: 4806

  More actions

  April 16, 2009 at 7:53 am

  #97555

  My requirement would be to send emails to managers & associated employee based on few business rules.

  The subject & body are different for each business rules. So I was thinking about adding a new table in the db to store the subject & body and pull the subject & body while sending emails.

  I'm using sp_send_dbmail from the stored procedure. I would like to see any best practices, table design practices if any.

  Thank you all.

• Vijaya Kadiyala

  SSCrazy Eights

  Points: 9149

  More actions

  April 17, 2009 at 10:32 am

  #979807

  table design is purely based on the requirement.

  Are there any other requirements around these emails? i.e if there is any change to the Body for a Line of Business do you want to update it or want to have version of the data!!

  Thanks -- Vijaya Kadiyala
  www.dotnetvj.com
  SQL Server Articles For Beginers

  
  

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737424

  More actions

  April 17, 2009 at 11:08 am

  #979848

  Here we do send quite a few emails. We have

  Table1 - Emails, put in the actual email text. may have tokens embedded that are replaced at send time.

  table2 - email recipients (who's getting a particular email), linked to table 1

  as we send, we update table2 with date/time and status.