Post reply

Database mail question

  • October 13, 2008 at 3:47 am

    #213982

    hi people.

    i've successfully set up a small alerting app that uses a job to periodically check a table for certain conditions which will fire off an after insert trigger. the trigger will send off an email to selected parties.

    My question is, can these parties reply to the email? im hoping that they can which will allow me to update a table which will contain details on who is attending to the problem...

    thanks...

  • October 13, 2008 at 6:38 am

    #884114

    For my knowledge it is possible for Database Mail to recieve e-mail. You have to re-route the mail address from Database Mail to your own.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • October 13, 2008 at 8:19 am

    #884158

    You can do this, but it's asking for trouble. It increases your surface area and potentially exposes you to sql injection.

    The only thing I might do it read the "from" in the email and then perform an update based on that value.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply