locked
accept smtp emails directly into ms sql database RRS feed

  • Question

  • User1247747107 posted

    Hi

    I want to write (or find already available) some service that listens on port 25 and any emails that arrive there are added into a database table.

    I don't want to execute any sql commands, I just want to insert the contents of the email directly into the database.

    When searching I can only find warning about executing SQL on the database e.g. with sp_processmail  which can't apply since I don't want to process the message, just store it.

    Anybody got any ideas?

    Thanks

    Tuesday, January 29, 2013 8:59 AM

Answers

  • User-166373564 posted

    Hi bendecko

    I don't know whether there is any service available to accept emails directly into database without executing any sql commands,

    I think you could consider posting this issue to SQL Server forums(http://social.msdn.microsoft.com/Forums/en-US/category/sqlserver),

    and check whether they have good solutions for you.

    If any community member has good idea for this, please give you kind response. Thanks!

    hope it helps you,

    With regards

     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, February 5, 2013 2:26 AM