email to sql server - how?

I am developing support ticket system and i want to know who's going to take care of the email sent to support@.domain.com, who's going to generate the ticket number, send automatic email and add the entry to the sql server?

You can create a .NET application that watches the mailbox,

OR,

you can explore using the SQL 2005 Service Broker service.

SQL Server 2005 DOES NOT receive email -and that is VERY GOOD, since it would be a security nightmare.

|||

One very easy way is to use VBA in Outlook to loop through the new mails and process them. Look in the newsgroup for outlook and there'll loads of examples. Maybe Exchange will let you do something similar to create a clientless server based solution, but i don;t know exchange very well.

Regards, Gert-Jan