Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jooorj
Posting Yak Master
126 Posts |
 Posted - 2011-04-23 : 14:40:40
|
| I know that sql server has a service for sending emails via management tools,so how can I make sql able to receive email & attachments files,because I have 50 10 users connected via internet and I need to receive their emails in sql database in order to save it in my database |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-04-23 : 14:55:16
|
| Better to write an application to receive the email and then save it to the database. SQL Server is not designed for this kind of function.The deprecated SQLMail function has a method for reading email: http://msdn.microsoft.com/en-us/library/ms179879.aspxHowever it will be removed, and cannot do POP, among other things. |
 |
|
|
jooorj
Posting Yak Master
126 Posts |
Posted - 2011-04-23 : 17:27:55
|
| how can i tell my manager to believe me! |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-04-23 : 18:04:45
|
| Show him/her this post, and the Microsoft documentation for SQL Server.Why does your manager believe SQL Server can receive email via POP? |
|
|
|
jooorj
Posting Yak Master
126 Posts |
Posted - 2011-04-24 : 01:35:16
|
| no, he asked me to search online about any way to receive emails.I coding a system in VB.NET to do all that , but it is not my point as I am a database developer not an email developer.as you know email use pop3 & MAPI & encoding base 64 & utf8-16 and so in ,it sound me like a headache. |
|
|
|
|
|
|
How can I receive email from pop using sql server?