?
Solved

Store incoming/outgoing mail in SQL Server 2000

Posted on 2004-11-10
8
Medium Priority
?
478 Views
Last Modified: 2008-01-09
Hi, please help me with this as I'm going nuts trying to find an answer.

We need to develop an application that stores all email, that is received through a specific email address, in SQL Server. What I'm looking for is a script that exports certain fields into a table when a message is received. I know that GFI already does this but this is not an option since the way it is stored in SQL Server sucks ass and we can't change it.

Hope to hear from you soon!
0
Comment
Question by:aquadis
  • 4
5 Comments
 
LVL 1

Expert Comment

by:jdhoover123
ID: 12551213
I don't suppose you could use an inexpensive Linux box as your MX relay, bring all email into it first, and use the Milter package to save out the parts you need into a MySQL or PostgreSQL server? The mail would just foward on to the "real" mail server when finished.

Hoov
0
 

Author Comment

by:aquadis
ID: 12581969
No sorry, this is not an option. The only software I have is Exchange 2003, en Windows Server 2003 and buying other soft- and/or hardware is not an option for this client. Come on guys/girls, is this too difficult for you (it is for me...)??
0
 
LVL 1

Expert Comment

by:jdhoover123
ID: 12584176
Here's somewhere to start... http://www.developersdex.com/gurus/articles/429.asp

Hoov
0
 
LVL 1

Accepted Solution

by:
jdhoover123 earned 2000 total points
ID: 12584255
Here's additional information on SQLMail (referenced in URL above): http://www.sqlteam.com/item.asp?ItemID=401
Note that it has links to more info at the top, including some MS KB articles.

Hoov
0
 
LVL 1

Expert Comment

by:jdhoover123
ID: 12584277
Yep, after further reading, this sounds like the way to go. Basically use SQLMail to create an Inbox for the SQL Server, and route your email address to that Inbox (either directly or sending a copy there). From there on, not too horrible - the second URL is the easiest to get through.

Hoov
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Here in this article, you will get a step by step guidance on how to restore an Exchange database to a recovery database. Get a brief on Recovery Database and how it can be used to restore Exchange database in this section!
Eseutil Hard Recovery is part of exchange tool and ensures Exchange mailbox data recovery when mailbox gets corrupt due to some problem on Exchange server.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question