Pull email from MS exchange server into a MS SQL Server 2000 DB...possible?

[angrycoder]

Is it possible to have a MS SQL Server poll and pull email from a certain account on an exchange server? if so, how?

basically, I'm making/modifying a message board to be able to allow people to send email to an address to create new posts or reply to existing threads and have these emails be posted on the online forum as well. It's all done in coldfusion, and their <cfpop> tag does not work with an exchange server (I cannot change settings on the exchange server). If SQL server can do this directly, it will be zero lines of code for me and really cool.

[Rune Bivrin]

You should be able to do this by using CDONTS and the OLE Automation stored procedures (sp_OACreate etc.). It's hardly zero lines of code, though.

Rune