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.
bendecko
0 Points
9 Posts
accept smtp emails directly into ms sql database
Jan 29, 2013 12:59 PM|LINK
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
Angie xu - M...
All-Star
20277 Points
1726 Posts
Microsoft
Re: accept smtp emails directly into ms sql database
Feb 05, 2013 06:26 AM|LINK
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
Feedback to us
Develop and promote your apps in Windows Store