Store incoming/outgoing mail in SQL Server 2000

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!
aquadisAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jdhoover123Commented:
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
aquadisAuthor Commented:
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
jdhoover123Commented:
Here's somewhere to start... http://www.developersdex.com/gurus/articles/429.asp

Hoov
0
jdhoover123Commented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jdhoover123Commented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Exchange

From novice to tech pro — start learning today.